remove quotation marks when saving table to a text file...

G

Guest

I'm using the following command to save the contents of a table into a text
file:

DoCmd.TransferText acExportDelim, , "Test_Table", "my_text_file.txt", False

In the resulting text file however, there are quotation marks before and
after each entry. Does anyone here know how I can avoid these quotation marks?
 
G

Guest

Just to add...

The original table does not have these quotation marks. They only appear in
the text file.
 
V

Van T. Dinh

Check Access VB Help on the TransferText Method and read carefully the
SpecificationName argument of the method.
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Top