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

  • Thread starter Thread starter Guest
  • Start date Start date
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?
 
Just to add...

The original table does not have these quotation marks. They only appear in
the text file.
 
Check Access VB Help on the TransferText Method and read carefully the
SpecificationName argument of the method.
 
Back
Top