Change default import settings

[Zodiac]

Hi all,

I have to do a lot of imports from a text file which is exporterted from
another system. The import wizard always uses " for text qualifier. I
always forget to change it to {} (none).

Is there a way to alter the default vaules of the Import wizard?

thks,

Z.

 

[Chip Pearson]

I don't believe there is any way to change the defaults.


--
Cordially,
Chip Pearson
Microsoft MVP - Excel
Pearson Software Consulting, LLC
www.cpearson.com

 

[Dave Peterson]

Maybe you could record a macro when you do it manually (and correctly <bg>).
Then next time you want to import a similar file, you just rerun your macro.