Thanks for looking!
I'm using a query to export a table to a text file, i.e.
SELECT * INTO [Text;HDR=No;Database=C:\].[test#txt]
FROM [TestTbl]
Text fields end up surrounded by double quotes as a text qualifier. Is there a property I can use to get rid of the text qualifier within the SQL (similar to how HDR=No gets rid of the headers)?
I've tried searching and guessing, but nothing has worked yet. Thanks!
I'm using a query to export a table to a text file, i.e.
SELECT * INTO [Text;HDR=No;Database=C:\].[test#txt]
FROM [TestTbl]
Text fields end up surrounded by double quotes as a text qualifier. Is there a property I can use to get rid of the text qualifier within the SQL (similar to how HDR=No gets rid of the headers)?
I've tried searching and guessing, but nothing has worked yet. Thanks!