How to set default value for Column Data Format in Excel Import Wizard in Registry

Copper Contributor

It would be nice to make it possible to change default Column Data Format (currently General) in Excel Text Import Wizard by making entry in Registry. I know it is possible to do it for Encoding Settings when you go to

 

HKEY_CURRENT_USER>Software>Microsoft>Office>14.0>Excel>Options


and add new DWord item named DefaultCPG and then write decimal value inside for encoding. SO if you write 65001 Unicode (UTF-8), or if you write 852 you will have Central European encoding and when you Start Text Import Wizard in Step 1 offered Encoding by default is one you defined in Registry.

 

Does anyone know is it possible to do this in Registry?

0 Replies