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.
Things You'll Need
- Microsoft 2007 or 2010
Click "Start > Microsoft Office > Microsoft Access."
Click "External Data" and then click "Text File." The "Get External Data - Text File" dialog box is displayed.
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.
Click "Import the source data into a new table in the current database" and then click "OK." The "Import Text Wizard" is displayed.
Click the "Delimited" radio button and then click "Next."
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.