Hi there,
I need to export table to a .csv file... but with the headers not surrended by doble quotes...
is it possible?
Regards,
Hi there,
I need to export table to a .csv file... but with the headers not surrended by doble quotes...
is it possible?
Regards,
In your Import Spec, be sure to set the Text Qualifier value to NONE instead of the default double-quotes.
Thanks for your answer.. I just want the headers not to have doble quotes... text in the content should have doble quotes, but not the headers.
I don't think you can do one without the other. I think it is an all or nothing proposition.
At least in using DoCmd.TransferText. I imagine it can probably be done by creating VBA code to explicitly write out the CSV file, line-by-line.
One workaround may be to export it without the headers, and just have the headers stored in a separate one line text file that you can append to the top of the file after it is exported.
Or maybe someone else will have some better ideas.