Access export to CSV - formatting problem

Question

I have created a macro that exports a query from Access to a csv file.  Within the csv file, I need some of the columns to be formatted as "General" and some to be formatted as "Text".

Right now, every time I run the macro, all columns are formatted as "General".  Is there a way to set it up so I don't have to manually charge the formats for each column each time I run the macro?  

Thank you.

Answer 1

That's what I was afraid of.  Thanks for letting me know.

Answer 2

A CSV file is a plain text file. There is no formatting. Even if you select General and Text. Once it gets into the CSV its not formatted. When you import the CSV to something else, that's where you need to set formatting.

Answer 3

I don't have A2007 in front of me, but in A2010 it is a button on the second step of the wizard.

Answer 4

Tom - thanks for the reply.  I'm still a relative newbie with Access...and I don't know how get to advanced options in the Export Wizard.  Any help would be appreciated.

Answer 5

When you step through the export wizard, have you tried the advanced options which allow you to specify a format for each column, and save that ExportSpecification so you can re-use it later in your macro?