doCmd.TransferText parameters

  • Thread starter Thread starter MVL
  • Start date Start date
M

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
 
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.
 
Back
Top