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" 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 |
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 |
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 |
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 |
"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 |
All times are GMT +1. The time now is 02:02 AM. |
Powered by vBulletin® Copyright ©2000 - 2024, Jelsoft Enterprises Ltd.
ExcelBanter.com