Although not as common as exporting to Excel, some projects may have a need to export in .csv format. Here is my solution. VBA Export With User Defined SQL Query This example uses the QueryDef function. Basically, the user passes a SQL query in, the file dialog prompts for where to save-as and the export is completed. 'To use file-dialog, you must add a reference 'to … [Read more...] about VBA Export to CSV From SQL With Save-As in Access