How to Import Data From CSV Files Into Access Tables

To import data from CSV (Comma Separated Values) files into Access tables, use the "Import" feature in Microsoft Access. The Import feature of Access allows you to read CSV and other flat files with delimiters into a Microsoft Access table. In many cases, CSV files are stored with the .txt (Text) extension. As long as each field in the file is separated by commas it is still considered a CSV file that can be imported into Access tables.

Businesswoman typing on computer
credit: BananaStock/BananaStock/Getty Images

Step

Click "Start > Microsoft Office > Microsoft Access."

Step

Click "External Data" and then click "Text File." The "Get External Data - Text File" dialog box is displayed.

Step

Click the "Browse" button and browse to your CSV file or type the full path name of your CSV file in the "File name:" section.

Step

Click "Import the source data into a new table in the current database" and then click "OK." The "Import Text Wizard" is displayed.

Step

Click the "Delimited" radio button and then click "Next."

Step

Click the radio button next to "Comma," click "Finish" and then "Close." In the "All Access Objects" box the new Access table created from the CSV file is listed.