Export specifications with DoCmd.OutputTo acOutputQuery

[Mattbro]

Hello All,
Using Access 2010, I have a query in a db that I regularly export. This produces a .txt file. Using the advanced option in the Export Text Wizard when exporting, I use the ‘specs’ box to use my predefined format that is saved in the list as ‘QueryExport Export Specification’.
I would like to automate the process into an on_click event and have got as far as:

 
‘DoCmd.OutputTo acOutputQuery, "QueryExport", "MS-DOSText(*.txt)", "C:\CP\Cextracts\QueryExport.txt", False, "", , acExportQualityPrint’

Which is great, but of course, doesn’t bring the ‘specs’ into play. Could anyone tell me if it can be done, and if so, how?


Many thanks,
Mattbro

[JoeM]

If you use TransferText instead of OutputTo, you can designate the Export Specs to use.

[Mattbro]

Yes!

DoCmd.TransferText acExportDelim, "QueryExport Export Specification", "QueryExport", " C:\CP\Cextracts \QueryExport.txt"

Thanks a lot.
M