Comma Deliminated File Format

[Olan Gotcher]

I need to save some files in a comma deliminated file format so that I can
retrieve them from an old dos data base. I can use excel to bring these
comma deliminated files in perfectly but it will only let me save them back
as a tab deliminated text file. The old dos program will only retrieve the
files if they are comma deliminated. I use excell to update these data
bases, e.g. sort by name, membership number and car number. These files are
for drag racing. I can import them into Access and then output in comma
deliminated from there but that adds a lot of extra work and time.

Any help would be appreciated.

Olan Gotcher

 

[kassie]

Click on File|Save As and scroll down past Tab Delimited, til you get to
Comma Delimited (CSV)

 

[Olan Gotcher]

I am using excel version 2003 and in my setup it does not have a comma
delimited file option. I am wondering if I re-install the software if their
is a comma option that I did not get in the first install. I used to do
this back a few years ago in version 2000, but I do not have that available
now.

Olan

 

[Gord Dibben]

Olan

I have never seen a typical installation that omitted the filetype *.csv

I guess if you do not have it in your Save As>Filtype(4th from the bottom) then
a re-install may help.

OR you can go to Chip Pearson's site and copy the code he has for exporting to a
*.txt file with your choice of a comma as a de-limiter.

http://www.cpearson.com/excel/imptext.htm


Gord Dibben MS Excel MVP

 

[Olan Gotcher]

Gord

I was able to use the csv file option but the program I am using requires
the ext. to be .txt so that it can find it. I am not sure if changing the
file name from *.csv to *.txt will actually work but I am going to try it
and see how that will work.

This program was written 20 years ago and is still used by 80% of all drag
race facilities in the US. I will try the file in the cpearson web site.
Hopefully that will work as I have to update about 22 different files before
next weekend for a big race in Chicago.

Thanks for your help
Olan

 

[Gord Dibben]

The change to *.txt works for me.

Gord

Gord

I was able to use the csv file option but the program I am using requires
the ext. to be .txt so that it can find it. I am not sure if changing the
file name from *.csv to *.txt will actually work but I am going to try it
and see how that will work.

This program was written 20 years ago and is still used by 80% of all drag
race facilities in the US. I will try the file in the cpearson web site.
Hopefully that will work as I have to update about 22 different files before
next weekend for a big race in Chicago.

Thanks for your help
Olan

Gord Dibben MS Excel MVP