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

0 answers