Home |
Search |
Today's Posts |
#1
|
|||
|
|||
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 |
#2
|
|||
|
|||
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" wrote in message ... 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 |
#3
|
|||
|
|||
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" wrote in message ... 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 |
#4
|
|||
|
|||
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" wrote in message ... 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 |
#5
|
|||
|
|||
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" wrote in message ... 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 |
#6
|
|||
|
|||
"Currie" wrote in message
... 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 |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
Excel 2003 FAILS, but Excel 2000 SUCCEEDS ??? | Excel Discussion (Misc queries) | |||
In excel, importing from anouther sheet background colors will no. | Excel Worksheet Functions | |||
Importing txt csv files into Excel greater than 65k lines | Excel Discussion (Misc queries) | |||
Difference in number of Excel NewsGroups | Excel Discussion (Misc queries) | |||
importing files into excel | Excel Discussion (Misc queries) |