Access 2002 - Export to tab delimited text without quotes

Posted on 2006-05-31
Last Modified: 2008-02-01
Hi experts,

My client would like me to export the results of a query to tab delimited text without quotes.  

I have tried the code:

DoCmd.TransferText acExportDelim, , "qryProductDirectoryExportUpdateNewFinal2", "C:\ProductDirectory.txt", True

...but I get a result that includes quotes and commas.  Any ideas?  

I would appreciate any help.  Thanks!
Question by:PhilTurano
    LVL 58

    Accepted Solution

    Hello PhilTurano

    You need to use an export specification.
     • do the export "by hand" ("file / export..." etc.)
     • while in the wizard, press [Advanced]
     • save the specification under any name (but write it down)
     • add that name as second parameter to your DoCmd.TransferText command

    Specifications allow the choice of the delimiter and also "none" for the text delimiter.


    Author Comment

    Thank you.  Works great.  

    Featured Post

    Looking for New Ways to Advertise?

    Engage with tech pros in our community with native advertising, as a Vendor Expert, and more.

    Join & Write a Comment

    Most if not all databases provide tools to filter data; even simple mail-merge programs might offer basic filtering capabilities. This is so important that, although Access has many built-in features to help the user in this task, developers often n…
    Overview: This article:       (a) explains one principle method to cross-reference invoice items in Quickbooks®       (b) explores the reasons one might need to cross-reference invoice items       (c) provides a sample process for creating a M…
    As developers, we are not limited to the functions provided by the VBA language. In addition, we can call the functions that are part of the Windows operating system. These functions are part of the Windows API (Application Programming Interface). U…
    With Microsoft Access, learn how to specify relationships between tables and set various options on the relationship. Add the tables: Create the relationship: Decide if you’re going to set referential integrity: Decide if you want cascade upda…

    729 members asked questions and received personalized solutions in the past 7 days.

    Join the community of 500,000 technology professionals and ask your questions.

    Join & Ask a Question

    Need Help in Real-Time?

    Connect with top rated Experts

    20 Experts available now in Live!

    Get 1:1 Help Now