Help with VBA

  • Thread starter Thread starter Terry Olsen
  • Start date Start date
T

Terry Olsen

not sure if this is the correct group...but....

I need to write data out to a file from a few queries (doing this in an
access module). How do I get to the data held in the queries?

Thanks,
Terry
 
If you want to send it out to a text file delimted use the TransferText
method of the Docmd. For example:

DoCmd.TransferText acExportDelim, "", "qryQueryName", "c:\filename.csv",
False, ""
 
Just open up the query by double clicking it and editing
it by toggling through design view and run window, once
this is working use the docmd.outputto command to plug it
into a text file or a excel spreadsheet .
Job done.
Jim.
 
Back
Top