Importing to Excel from ASCII

[Guest]

I'm trying to export to excel from an SQL based spreadsheet. I believe it's
ASCII CRLF. Sometimes when I open it as is, it will bring up the Text Import
Wizard, but then others it does not. And of course it all gets jammed into
one cell so I can't do anything with it. Please Help!!

Thnx,
Greg Currie

 

[Jim Rech]

If a text file has the CSV extension Excel will parse it automatically
(looking for commas as the delimiters). Otherwise Excel will open the TIW
from which you can parse the file by specifying the delimiters, etc.

If a file is not parsed for any reason (like it doesn't have the delimiters
Excel is told to look for) you can always use the Data, Text to Column
feature to parse the data sitting in column A. This feature is esentailly
the TIW without the importing.

 

[Guest]

So there is absolutely no way I can open the Text Import Wizard myself?
Excel automatically opens it if needed? I tried saving it as a CSV file and
it did nothing to help me. I opened it and it looked the same as saving it
as XLS. It's not delimited by commas at all so that's probably the problem.
Any other thoughts?

 

[Dave Peterson]

If you save the ASCII file as *.txt, then do File|Open, don't you see the
wizard?

 

[Guest]

Eureka! Thanks a lot!!!

If you save the ASCII file as *.txt, then do File|Open, don't you see the
wizard?

 

[David Biddulph]

So there is absolutely no way I can open the Text Import Wizard myself?
Excel automatically opens it if needed? I tried saving it as a CSV file
and
it did nothing to help me. I opened it and it looked the same as saving
it
as XLS. It's not delimited by commas at all so that's probably the
problem.
Any other thoughts?

What happens if you name it .txt, and then try to open it from Excel?