Access 2016: Import Data into Access
Access provides an easy way to import data from external files.
You can easily import data from a variety of different sources, including text, Excel, XML, HTML, ODBC datasources and more.
You can also link to external data sources, so that changes in the source file are reflected in your Access database.
Generally, when importing data, you have these options:
- Import the data into an existing table;
- Have Access create a new table based on the data; or
- Establish a link to the external file, so that future updates are reflected automatically.
Today, we'll import data into an existing table.
Import a CSV File into an Existing Table
We will import the following CSV file into the Artists table.
Source File: artists.csv
1, AC/DC, 1973
2, Louis Armstrong, 1914
3, Iron Maiden, 1975
4, Miles Davis, 1944
5, Pat Benetar, 1972
6, Stevie Ray Vaughan, 1965
7, Avenged Sevenfold, 1999
8, Destiny's Child, 1990
9, Snoop Dogg, 1992
Destination table: Artists
You can download the CSV file here: artists.csv
Note that this file includes an extra field that's not in our destination table. Not a problem. Access will allow us to remove the extra field.
Also, the CSV file doesn't contain a header row, but that's fine. Access can deal with this too.