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

How to Keep Excel Sheet Formatting On a CSV Sheet with vba 1
Export Table as a csv file 1
Transfertext enclose number fields in quotes 6
Access Importing csv daily files into access 2007 1
Access to CSV 2
Date Format Incorrect on Export 1
Exporting time with date 2
Export Wizard to csv 2

Top