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

Hi,

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
edit delete
are you sure?
asked Jamie Alford

0 answers

Post an answer but please login first

Post Answer
  1. Please login to post answer

Similar Questions

Tagsfor this question

Forumall questions