How to Export Access Query as CSV
CSV text files are ideal for emailing because of their small file size and multi-program compatibility. CSV files are text files formatted as a spreadsheet with commas separating the values. Because CSV files are text files, they are stripped of formatting such as bold and italics. A Microsoft Access query takes information from the table based on set criteria. Once the query is run, the resulting query table can be exported as a CSV text file.
Open Microsoft Access. Select the query in the navigation pane.
Right-click the query and select "Export." Choose the "Text File" option. Export is also available under the "External Data" tab on the top menu bar. Click the "Text File" button in the "Export" box.
Place your cursor at the end of the file name and delete the "txt" file extension. Type "csv" and click "Browse" to specify your destination folder. Click "OK."
Click the radio button next to "Delimited." Click "Next."
Specify your delimiter type: tab, semicolon, comma, space or other. Click "Next" and "Finish."