View Single Post
  #4   Report Post  
Posted to microsoft.public.excel.misc
Gord Dibben Gord Dibben is offline
external usenet poster
 
Posts: 22,906
Default 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