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.

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



"Zodiac" wrote in message
. 16...


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.

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.

Zodiac wrote:

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.

--

Dave Peterson