Exporting CSV file using VBA

M

Martin

Hi,

I want to export data from an Access table into a CSV file
at a click of a command button. How do you do this with
VBA without using the built in wizard.

Martin
 
D

Douglas J. Steele

Call the TransferText method. Check the Help file for a list of what options
are available, and an example.
 

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

Similar Threads

Adding data to MS Access from csv file 0
Export BPMN Visio Chart to Excel 0
Creating a Search using a combo box and then creating a report. 4
Set as Default Template not working 0
VBA - exporting serial letters to single documents 0
Closing PDF file from Excel VBA (Adobe Reader, Adobe Acrobat, Browser) 0
How To Compare Two Csv Files Mainly Two Columns Containing Time 0
VBA concatenate ranges into a new document 0

Top