Convert Access Query to .csv file

[dcliffo]

I would like to assign a macro to a command button that will automatically convert an Access query file to a .csv file. Too bad Access doesn't have a "record macro" feature like Excel and this would be a piece of cake!

Can anyone help me?

 

[Norie]

Use the TransferText method.

You'll need to create an import specification.

Just run through a text export from the File menu and set the appropriate values, click advanced and save "CSV Specification"

 

[dcliffo]

Thank you, but then how do I assign this to a command button or open it up the next time.

I'm old and a big dufus....

 

[dcliffo]

I solved my problem! I also solved the problem of the date being exported with the seconds. By using a query and a calculated field for the date, you can suppress the seconds and put the date in any format that you need exported to the Excel file.

I also created a Macro by using the TransferText command and saving an export specification file as you had recommended. I added the command button onto my form and it works perfectly. When you open the .csv file in Excel, all of the exported fields show up correctly...even the date.

Thanks for the help in getting my brain to work!!!