Access 2007 - Export macro to csv

[Monoceros]

I want to export a query to a csv-file using a macro.

Is this possible ? The Output Format doesn't list csv as an option.

 

[boblarson]

I want to export a query to a csv-file using a macro.

Is this possible ? The Output Format doesn't list csv as an option.

Look to the TRANSFERTEXT action.

 

[Monoceros]

TransferText doesn't seem to exist anymore in Access 2007.

 

[boblarson]

TransferText doesn't seem to exist anymore in Access 2007.

It's there. You just have to make sure to press the SHOW ALL ACTIONS button. See here for a pic.

 

[Monoceros]

Thank you for the input.

It seems that I have to create a specification name to determine how to export the text file.

How do I do that ?

 

[boblarson]

Thank you for the input.

It seems that I have to create a specification name to determine how to export the text file.

How do I do that ?

In 2007 you select your table or query and then click on the EXTERNAL DATA tab and then under EXPORT choose TEXT FILE. DO NOT check the checkbox which says EXPORT data with formatting and layout.

Click OK and then you can follow the rest of the instructions here.