Comma Deliminated File Format
 

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

Comma Deliminated File Format
 

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

"Olan Gotcher" wrote:

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

Comma Deliminated File Format
 

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


"kassie" wrote in message
...
Click on File|Save As and scroll down past Tab Delimited, til you get to
Comma Delimited (CSV)

"Olan Gotcher" wrote:

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

Comma Deliminated File Format
 

Olan

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

I guess if you do not have it in your Save AsFiltype(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

On Sat, 15 Jul 2006 16:23:24 -0500, "Olan Gotcher" wrote:

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


"kassie" wrote in message
...
Click on File|Save As and scroll down past Tab Delimited, til you get to
Comma Delimited (CSV)

"Olan Gotcher" wrote:

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

Comma Deliminated File Format
 

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" <gorddibbATshawDOTca wrote in message
...
Olan

I have never seen a typical installation that omitted the filetype *.csve
I guess if you do not have it in your Save AsFiltype(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

On Sat, 15 Jul 2006 16:23:24 -0500, "Olan Gotcher"
wrote:

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


"kassie" wrote in message
...
Click on File|Save As and scroll down past Tab Delimited, til you get to
Comma Delimited (CSV)

"Olan Gotcher" wrote:

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

Comma Deliminated File Format
 

The change to *.txt works for me.

Gord

On Sat, 15 Jul 2006 18:11:05 -0500, "Olan Gotcher" wrote:

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" <gorddibbATshawDOTca wrote in message
.. .
Olan

I have never seen a typical installation that omitted the filetype *.csve
I guess if you do not have it in your Save AsFiltype(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

On Sat, 15 Jul 2006 16:23:24 -0500, "Olan Gotcher"
wrote:

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


"kassie" wrote in message
...
Click on File|Save As and scroll down past Tab Delimited, til you get to
Comma Delimited (CSV)

"Olan Gotcher" wrote:

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







Gord Dibben MS Excel MVP