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.
 

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

Similar Threads

TransferText command 1
VB code to export table to txt file 5
Inability to add quotation mark around a variable by concatenation in VBA 4
ActiveWorkbook.Save - adds quotation marks to the file content 1
DoCmd.TransferText acExportDelim, , "Tbl_Temp2", "C:\Test1.txt" 2
excel save as csv quotation mark 1
Saving txt files with quotation mark delimiters 2
Excel CSV file: How to preserve double quotation mark on Unix ftp? 2

Back
Top