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

A

Anakin Moonwalker

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?
 
A

Anakin Moonwalker

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.
 
Top