doCmd.TransferText parameters

Thread view:

Enable EMail Alerts

Start New Thread

Thread rating:

MVL - 06 Aug 2004 14:19 GMT

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

Reply to this Message

John Nurick - 06 Aug 2004 19:14 GMT

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.

>I'm trying to export a query into a text file but cannot
>find the VBA parameters for exporting a tab delimited
[quoted text clipped - 4 lines]
>DoCmd.TransferText acExportDelim, ????, "qTransmission
>TMC", filepath & filename

--
John Nurick [Microsoft Access MVP]

Please respond in the newgroup and not by email.

Reply to this Message