Access 2002 - Export to tab delimited text without quotes

Posted on 2006-05-31
Medium Priority
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

harfang earned 500 total points
ID: 16803220
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

ID: 16803565
Thank you.  Works great.  

Featured Post

Free Tool: SSL Checker

Scans your site and returns information about your SSL implementation and certificate. Helpful for debugging and validating your SSL configuration.

One of a set of tools we are providing to everyone as a way of saying thank you for being a part of the community.

Question has a verified solution.

If you are experiencing a similar issue, please ask a related question

Explore the ways to Unlock VBA Project Password Excel 2010 & 2013 documents. Go through the article and perform the steps carefully to remove VBA Excel .xls file.
If you’re using QODBC to update QuickBooks data from Microsoft® Access but Access is not showing the updated data, you could have set up QODBC incorrectly.
With just a little bit of  SQL and VBA, many doors open to cool things like synchronize a list box to display data relevant to other information on a form.  If you have never written code or looked at an SQL statement before, no problem! ...  give i…
How can you see what you are working on when you want to see it while you to save a copy? Add a "Save As" icon to the Quick Access Toolbar, or QAT. That way, when you save a copy of a query, form, report, or other object you are modifying, you…

621 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