Feb 25 2004, 02:34 PM
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.
Feb 25 2004, 02:36 PM
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...
Feb 25 2004, 02:39 PM
OK, so how do I invoke the export wizard?
Feb 25 2004, 02:49 PM
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.
Feb 25 2004, 02:53 PM
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.
Feb 25 2004, 03:10 PM
You are welcome and good luck...
This is a "lo-fi" version of our main content. To view the full version with more information, formatting and images, please click here