How to Import Data From Excel
1. Click on the External Data tab in the Access ribbon2. Select "Import Excel Spreadsheet"
3. If you are updating an existing table, select "Append a copy of the records to the table:" and select the appropriate table. If you are creating a new table from the Excel data, select "Import the source data into a new table in the current database."
4. Follow the instructions in the wizard for formatting your data. You may either opt to select your own Primary Key or allow Access to assign a primary key to your data (recommended).
5. Future Excel imports to the same table must follow the exact format of the current table in the database - so if you made changes to your Excel document since the first import, you will have to reverse those changes in order for the data to append properly. Alternatively, you can delete the table and re-import the data, but you will have to first delete any existing relationships between that table and other tables and/or queries before Access will allow you to do this.
InternalDatabaseKeyVotes
