Programmatically exporting to CSV file...
-
Greetings everybody: I need to know how to export a database query to a .CSV file instead of to a MS Excel file. The code is as follows to export to MS Excel, but how do I export to a .CSV file?
DoCmd.TransferSpreadsheet acExport, acSpreadsheetTypeExcel9, _
"qryFinalResult", strOutputFilePath, True -
Greetings everybody: I need to know how to export a database query to a .CSV file instead of to a MS Excel file. The code is as follows to export to MS Excel, but how do I export to a .CSV file?
DoCmd.TransferSpreadsheet acExport, acSpreadsheetTypeExcel9, _
"qryFinalResult", strOutputFilePath, Trueyou could just use string builder and build the thing yourself.
Grady Booch: I told Google to their face...what you need is some serious adult supervision. (2007 Turing lecture) http://www.frankkerrigan.com/[^]