Saving Access 2010 Query Results to a CSV formatted file

I have created an Access 2010 query that sends over 800,000 results.  I want to use VBA to run the query and send the results to a comma delimited CSV file.

Do I use the DoCmd.TransferText command to do this?

Thanks

Glen
GPSPOWAsked:
Who is Participating?

[Webinar] Streamline your web hosting managementRegister Today

x
 
Rey Obrero (Capricorn1)Connect With a Mentor Commented:
<Do I use the DoCmd.TransferText command to do this?> yes, but

you need to create an export specification first..

1.right click on the table/query
2.select export > Text file
   click on Browse and locate the destination folder
3. (you can accept the proposed name or change it)
click Save, then click OK
4. In the export text wizard select the type (Delim / Fixed width)
5. Follow the wizard, before clicking on Finish
     5a .Click Advanced
6. In the Export Specification dialog box Field Information List, correct any descrepancies

7. click save as, give the specification a name <-- this is the specification name that you will use in the command line below


DoCmd.TransferText acExportDelim, "ExportSpecName", "TableQueryName", "C:\myCsv.csv", True
0
 
chris bennettsCommented:
I have tried this, it does not work.

I have 3 million rows output by a query, and this just crashes when going to "Export Text" and tells me that it can only paste 65000 rows to the clipboard

please advise..

thanks
0
All Courses

From novice to tech pro — start learning today.