doCmd.TransferText parameters

[MVL]

I'm trying to export a query into a text file but cannot
find the VBA parameters for exporting a tab delimited
file.

This is what I have so far:

DoCmd.TransferText acExportDelim, ????, "qTransmission
TMC", filepath & filename

 

[John Nurick]

Hi MVL,

You need to create an export specification (to do so, export the query
manually and click the Advanced... button in the wizard) and pass its
name to TransferText.

Alternatively, create a SCHEMA.INI file in the export directory.