Can I export to a text file via a query without wrapping quotes around my strings?


I'm trying to do an export from access into a text file via a query

select CustomerName
into [Text;FMT=TabDelimited;HDR=NO;DATABASE=C:\Temp;].CustomerList.txt
from Customer

however, every line is getting wrapped in double quotes. Is there a way to turn off the quoting (I'm only ever setting one column), or can I use a custom quote character (e.g. set it to blank)?

edit delete
are you sure?
asked Jamie Alford

0 answers

Post an answer but please log in first

Post Answer
  1. Please log in to post answer

Similar Questions

Tagsfor this question

Forumall questions