csv file creation

[Guest]

I have a client who requires a csv file, currently created from an excel
spreadsheet. He wants to generate the file from an Access database. If I
create the csv file in Excel the text fields do not have double quotes ""
enclosing them, however if I create the csv file from Access then double
quotes are generated. How can I write the file without the double quotes in
Access?

 

[Guest]

You can set up an Export Spec to make that happen. To do that, do an export
manually from the menu. when you get to the export wizard, there will be an
"Advanced" command button in the lower left of the wizard dialog - Click that.
One of the options is "text qualifier". Select {None}. Once you have that
and any other options you want, save it with a name. Then when you do the
TransferText from code, the second arguement is SpecificationName. Give it
the name of the spec you set up and you will get it in the format you want.