Access: Export queries as a CSV file
You can also export queries in Microsoft Access as a space-saving CSV file. You can find out how this works in this practical tip.
Save the access query in CSV format
- Open the relevant database in Access and switch to "Queries" in the left navigation bar.
- Right click on the query you want to save as CSV and go to "Export"> "Text File".
- In the new window you determine the storage location, file name and thus also the file format: First go to "Browse" and select the location where the CSV file is to be saved.
- Then change the file extension in the text line: Simply remove the ".txt" extension and enter ".csv" instead.
- In the other windows you can specify even more precise properties for the file - such as the separators used. If all settings are OK, click on "Finish" and the CSV file will be exported.
The instructions refer to Microsoft Excel 2010 under Windows 8.1. You can get tips on how to clean up the user interface in Access in this article.