ExcelBanter

ExcelBanter (https://www.excelbanter.com/)
-   Excel Discussion (Misc queries) (https://www.excelbanter.com/excel-discussion-misc-queries/)
-   -   Saving as CSV File (https://www.excelbanter.com/excel-discussion-misc-queries/187295-saving-csv-file.html)

Steve Wade

Saving as CSV File
 
I am attempting to save a worksheet as a CSV or TXT file to import into
another program. When I attempt to save as the nly file options presented are
xls or all file types. I save the file with a csv extension.

When I attempt to import the file it is not recognized as a CSV. Save thing
when I save as txt.

Am I missing something. Using Excel 2003 SP#.

Note we are also integrated with Hummingbird DM5 (OPEN TEXT)

JoeSpareBedroom

Saving as CSV File
 
"Steve Wade" wrote in message
...
I am attempting to save a worksheet as a CSV or TXT file to import into
another program. When I attempt to save as the nly file options presented
are
xls or all file types. I save the file with a csv extension.

When I attempt to import the file it is not recognized as a CSV. Save
thing
when I save as txt.

Am I missing something. Using Excel 2003 SP#.

Note we are also integrated with Hummingbird DM5 (OPEN TEXT)



If it's anything like Excel/Office 2000, I believe you have to install that
feature. Might not be part of the default installation. There's quite a long
list of filters available on the install CD, and MS correctly assumes that
many users won't need them all.



aushknotes

Saving as CSV File
 
Try open your file with notepad. If you see comma in between fields, it is csv.

"Steve Wade" wrote:

I am attempting to save a worksheet as a CSV or TXT file to import into
another program. When I attempt to save as the nly file options presented are
xls or all file types. I save the file with a csv extension.

When I attempt to import the file it is not recognized as a CSV. Save thing
when I save as txt.

Am I missing something. Using Excel 2003 SP#.

Note we are also integrated with Hummingbird DM5 (OPEN TEXT)



All times are GMT +1. The time now is 07:02 PM.

Powered by vBulletin® Copyright ©2000 - 2025, Jelsoft Enterprises Ltd.
ExcelBanter.com