Access query in CSV Format
- Open the database in Access and go to the left navigation bar, click "queries".
- Click with the right mouse button on the query that you want to save as a CSV and go to "Export > text file".
- In the new window, you determine the location, file name and the file format: first Go to "Browse" and select the location where the CSV file is to be saved.
- You then change the file extension in the line of text: just Remove the ending ".txt" and wear them instead."csv" a.
- In the other screens, you can define more properties for the file - for example, the separators used. If all the settings are OK, click on "finish" and the CSV file is exported.
Export a query in Access
The guide refers to Microsoft Excel 2010 under Windows 8.1. Tips on how you can Access the user interface clean-up, you will get in this article.
