Export CSV

[dmyoungsal]

I have my automated export running via task manager and it is creating an Excel sheet. That is fine, but the real solution would be to have a comma delimited file.

If I change the format to csv, it comes out with "formatting" instead of a comma delmited data.

To those that have not seen my other posts, I am running the export via the autoexec macro and the only text file type is text and comes out formatted with column and headers formatted with dashes vertical lines.

Ideas?

 

[CJ_London]

how are you exporting? If using transferspreadsheet, instead you need to use transfertext.

 

[sneuberg]

This

DoCmd.TransferText acExportDelim,,[TableName],DestinationPath & "Filename" & "_" & format(Now(),"yyyy-mm-dd hh_nn") &".csv",...

was a suggestion in this thread

I tried this and don't see any formatting. I'm getting just comma delimited data.
Have you been trying this or something else?