Export data to Text file

  • Thread starter Thread starter Adam
  • Start date Start date
A

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
 
Adam said:
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
Click to expand...

See the online help for DoCmd.TransferText.
 
Back
Top