Export data to Text file

[Adam]

Hi,

I want to export data from a query or table to a text file
by using a command button on a form.

I know how to do this from the Menu and to send data from
a report ( ie DoCmd.OutputTo acReport, stDocName) , but I
would like to automate a procedure in relation to queries
and tables.

Using VB Editor, how do I do this may I ask?

Thank you.

Adam

 

[Dirk Goldgar]

Hi,

I want to export data from a query or table to a text file
by using a command button on a form.

I know how to do this from the Menu and to send data from
a report ( ie DoCmd.OutputTo acReport, stDocName) , but I
would like to automate a procedure in relation to queries
and tables.

Using VB Editor, how do I do this may I ask?

Thank you.

Adam

See the online help for DoCmd.TransferText.