How to Export Data From an Access Table to a CSV File

Comma separated values (CSV) are a type of text file. CSV files are typically used for files that are in a spreadsheet layout. CSV files are viewable in basic text editors and spreadsheet software such as Microsoft Excel. Microsoft Access tables are set up in a grid layout similar to a spreadsheet. You can export Access tables as CSV files to view in spreadsheet software or to import into a new database.

Instructions

1. Open Microsoft Access. Select the table that you want to export.

2. Select "External Data" on the top menu bar. Click the "Text File" button located in the "Export" box.

3. Delete the ".txt" from the file name and type ".csv" to replace it. Click the "Browse" button to designate a save location for your exported file. Click "Save" when you choose your location.

4. Choose your export options. The options include exporting with formatting and layout, opening the file when exported and exporting select records. Click the "OK" button.

5. Select the radio button next to "Delimited." Click "Next."

6. Select the radio button next to "Comma." Click "Next," "Finish" and then "Close."

References

• Microsoft: Introduction to Importing and Exporting Data