How to Import Access Data From a Linked Table to an Existing Table
When importing data into your Access database, you are given the option to append a copy of the data into an existing table. This process is done using the Import Spreadsheet Wizard. The wizard lets you select the table that contains the linked data. Once this data is imported into your database, it can be appended to an existing table. The linked table will resemble an Excel spreadsheet and is accessible in your tables section of the Navigation Pane.
Other People Are Reading
Instructions
-
-
1
Open Access 2010 and click the "File" tab. Click "Open" and browse the files to locate the database. Double-click the database to open it.
-
2
Click the "External Data" tab and select "Excel" from the Import & Link group. Click the Browse button and search for the Excel workbook. Click the workbook and select the "Open" button. Click "OK." The Import Spreadsheet wizard will open.
-
-
3
Click the sheet that contains the data you need and click "Next." Verify the columns that will be imported. Click "Next." Type a name for this linked table and click "Finish." Review the confirmation message and click "OK."
-
4
Click "Create" and "Query Design." The Show Table dialog box will appear. Select the linked table and click the "Add" button. Close the Show Table dialog box by clicking the "Close" button.
-
5
Add the fields linked table into the query by clicking field names and dragging them into the query. Click the "Append" icon on the ribbon. Select the existing table name from the drop-down list and click "OK." Access will prompt you to confirm the append action. Click "Yes."
-
1
