Export question

[Joe Blow]

Hello all:

Thanks for all your help.

I am looking to write a line in a module to export the results of a query to
a comma-quotes delimited file.
I created the "Export Specification", but I cannot find the right command to
use.

I tried "Output To", but I cannot define the export spec. DoCmd.OutputTo
acQuery, ....etc
I tried "TransferText", but that is only for tables.
DoCmd.TransferText acExportDelim, ...etc

I cannot store the results of the query to a table then export the table.
I need to export the query from the module directly.


Any ideas?

Thanks,

-Joe

 

[Ken Snell \(MVP\)]

DoCmd.TransferText is the right method to use. Second argument is where you
specifiy the export specification. TransferText will export a table or a
query.