How to Export Query to a CSV File

Export queries to CSV files by using the External Data tab.

Access queries are a great resource to get data out of a database, and an Access query can search for specific data. When you create the query, select the fields and criteria needed for your query output. Once this information is specified, the query can be exported to a compatible file format so you can use it with other software. The export feature is located on the External Data tab on the ribbon.

Instructions

1. Open Access 2007 and select a database. Click the "Office" button and select "Open." Browse your network for a database and click on it. Select the "Open" button. The database opens.

2. Press "F11" to maximize the Navigation Pane. Locate your queries in the database. Double-click on one of the queries and view the queries output. Select the "External Data" tab and select the "Text" button. The Export Text file dialog box appears.

3. Modify the file name to have the extension of ".csv." Click "OK." The Export Text Wizard appears. Select "Delimited." Click "Next." Select "Comma" at the delimiter prompt and click "Next." Verify the file name and destination location. If necessary change the file extension to ".csv." Click "Finish" and "Close."

References

• Microsoft: Export data to a text file

Resources

• Microsoft: Access How To & Help