Does anyone know a way to output a query or table in a CSV format? Right now I am just exporting as an excel file, but have to open excel later and save as a csv.

Coby.

Export it as an xls file, then rename it using Scripting.FileSystemObject. That should work without getting a changing extensions warning. Actually, instead of renaming it, copy and paste it, then delete the xls just to make sure you don't get the warning.

Did that help?

mmcdonal

Hi Coby,

Just export it as a text file

try this

 DoCmd.TransferText acExportDelim, This is for a specification name, "Name of your table or query here", your file name or variable, True if you want filed name - false if not

This will export as a csv file

Great!
Thanks guys . . . I am going to set it up both ways and see how it fits into what my users are doing.

I went with the method of just exporting it as a text file and it was exactly what I am looking for, especially because the column headings are omitted.

I do, however, has other uses for the info given by mcmdonal which gave me some other ideas.

So, I got bonus knowledge on this one.

Thanks you both of your input!

Coby.