Export to csv

S

Steven

I need to export to a csv file but do not put quotes around the data.

Can this be done?

Thank you,

Steven
 
M

Marshall Barton

Steven said:
I need to export to a csv file but do not put quotes around the data.


Use the File - Export menu to manually export the
table/query to CSV type file. Use the Advanced button to
specify how to delimit the fields and save the
specifications.

You can then reload the saved Import/Export specs the next
time you want to export the same table/query. If you want
to do it using code (behind a button on a form?), you can
use the TransferText method (see VBA Help for details) with
the previously saved specs.
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Top