I have built a SQL Table (say tblString) that consist of one field - which holds comma separated data - for example: 24/04/2010,$220.00,$22.00,12345 - Record 1
24/04/2010,$440.00,$44.00,12346 - Record 2
I need to write these records to an output text (.txt) file which I attempted to do via a
DoCmd.TransferText acExportDelim, "tblString", "C:\OutFile.txt"
This works in the main except the records in the Output.txt file are wrapped in double quotes
for example based on the above sample the records appear as
It is important that the Output.txt records reflect the input record structure - in other words without the double quotes as the next step in the process is to use the Output.txt file as a CSV file to be import into a separate application.
Is there any way I can write the records to the Output.txt file with out the double quotes. I've tried a number of alternatives - Do.Cmd.OutPutTo acOutputReport, DoCmd.OutPutTo acOutputFile etc but I still run into problems - for example DoCmd.OutputReport imbeds blank lines.