I have a table called 'Table1'. I want it's data exported to the file 'c:\data.csv' in CSV format. Is this the correct syntax?

DoCmd.TransferText acExportDelim, "SpecName", "Table1", "c:\data.csv"


For a CSV file, I suppose I should use an export specification, but I can't figure out how to create one.

When you are using the export Wizard you should see a button called Advanced. When you get to the last screen of the Wizard click the Advanced button and there you will find out how to save the spec...

hth,
Jack

OK, so how do I invoke the export wizard?

I just grabbed this from Access help:

In the Database window, click the name of the table, query, view, or stored procedure you want to export, and then on the File menu, click Export.

In the Save As Type box, click Text Files (*.txt;*.csv;*.tab;*.asc).

Click the arrow to the right of the Save In box, and select the drive or folder to export to.

In the File Name box, enter the file name, and then click Save All.
Microsoft Access starts the Export Text Wizard.

Follow the directions in the dialog boxes. Click Advanced to create or use an import/export specification.

hth,
Jack

OK! I got it. I had always stopped short of actually exporting the data. As soon as I clicked on "Save", the wizard started up.

Thanks.

You are welcome and good luck...

Jack