Export as CSV with Commas

[access2010]

I would like to export fields from Access 2003 with a comma pragmatically added between each field as a CSV file.

I am able to export the fields without the comma, but the Accounting Program that I want to use for the importing of the data requires a comma to separate each field.

Example
one,two,three,four,five

Thank you for your suggestion

Paul

 

[Cronk]

Use docmd.transferText

There's many examples if you search these forums as well as the wider web.

 

[Alansidman]

Here is a link to the syntax.

http://msdn.microsoft.com/en-us/library/office/aa193080(v=office.10).aspx

 

[spikepl]

The kill-radius of Access (i.e. the zone within which it eradicates all life upon blowing up) is virtually nil.

Click the buttons of the user interface and see what happens. Sooner or later you'll get to the right ones: export. Keep clicking. It will not kill you!

 

[highandwild]

You have to be careful here as if you just use a comma to delimit data items then
coping with embedded commas within the value of an item may cause the import routine to fail.

The nature of the data in your case may mean that this is unlikely to cause a problem.

 

[access2010]

Thank you for your suggestion.