Exporting Query Results

[mlamont]

What I would like to do is have a user click on a button and by doing so a file, preferably a text file (*.txt) file would be exported to the hard drive. However, I am unsure about the code I should use.

Can anybody help me?

Mike

 

[Sohaila Taravati]

The simplest way is to make a Macro and choose the Action: Output To. Then at the bottom you can choose your table or query or whatever to be sent to a folder. I hope that made sense to you

 

[Pat Hartman]

The TransferText Method/Action has more specific options as well as allowing you to reference a previously created export spec.