Importing to Excel from ASCII

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

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.

--
Jim
"Currie" <[email protected]> wrote in message
news:[email protected]...
> 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

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?

"Jim Rech" wrote:

> 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.
>
> --
> Jim
> "Currie" <[email protected]> wrote in message
> news:[email protected]...
> > 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
>
>
>

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



Currie wrote:
>
> 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?
>
> "Jim Rech" wrote:
>
> > 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.
> >
> > --
> > Jim
> > "Currie" <[email protected]> wrote in message
> > news:[email protected]...
> > > 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
> >
> >
> >

--

Dave Peterson

Eureka! Thanks a lot!!!

"Dave Peterson" wrote:

> If you save the ASCII file as *.txt, then do File|Open, don't you see the
> wizard?
>
>
>
> Currie wrote:
> >
> > 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?
> >
> > "Jim Rech" wrote:
> >
> > > 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.
> > >
> > > --
> > > Jim
> > > "Currie" <[email protected]> wrote in message
> > > news:[email protected]...
> > > > 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
> > >
> > >
> > >
>
> --
>
> Dave Peterson
>

"Currie" <[email protected]> wrote in message
news:[email protected]...
> 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?
--
David Biddulph