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.

...
CSV is a type of file format compatible with multiple software programs.

Step

Open Microsoft Access. Select the query in the navigation pane.

Step

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.

Step

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.”

Step

Click the radio button next to “Delimited.” Click “Next.”

Step

Specify your delimiter type: tab, semicolon, comma, space or other. Click “Next” and “Finish.”