Export query to a tab delimited text file

[Swifey]

Could you please help? I am wanting to automatically export a query as a Tab Delimited Txt file.
But when I write a macro to export the query it exports it in the wrong format.

For example my following code


DoCmd.OutputTo cQuery, "Q_PostSector", "MS-DOSText(*.txt)", "\\cmq0059\\Customer Relationship Management\Customer\Data\Post Sector.txt", False, "", 0 exports the file in the following format
---------------------------------------------------------------
salesoffice | reparea | customerno |
---------------------------------------------------------------
2 | 3 | 12 |
----------------------------------------------------------------

But when I exported file manually through the wizard I get following format

"URN" "customer" "name" "rank"
"10/05" "05" " Ltd " "0"

Kinds Regards
[/code]

 

[Russell Hauf]

Use the TransferText method instead, with the acExportDelim TransferType. Post back if you need more details.

-Russell

 

[Swifey]

Hi - I tried the following code, but it dosnt recognise my query I want to export to a shared directory.

DoCmd.TransferText acExportDelim, "Q_PostSector", "MS-DOSText(*.txt)", "\\cmq0059\\Customer Relationship Management\Customer\Data\Post Sector.txt", False, "", 0

Kind regards

 

[Russell Hauf]

Check Help for how TransferText is used. I don't think you need the MS-DOS part. Just try something like:

DoCmd.TransferText acExportDelim, , "Q_PostSector", "\\cmq0059\\Customer Relationship Management\Customer\Data\Post Sector.txt", True

Hope this helps,
Russell

 

[Swifey]

Thank you