How to Copy Access Data From a Linked Table to an Existing Table
Linked tables in Access can be copied to an existing table by doing an append query. The append query is one of the action query types in Access. Action queries let you perform an action on your database. Append queries let you append data from one table to another. An easier way to conduct the append query is to import the linked table into an existing table.
Other People Are Reading
Instructions
-
-
1
Open Access 2010 and select a database. Click the "File" tab and select a database from the recently used database list in the File menu. The database opens.
-
2
Click the "External Data" tab and select "Excel" from the Import & Link group. Click "Browse" and locate the workbook that you want to import. Click the table and select "Open." Select "Append a copy of the records." In the drop-down list, click the table that will contain the copied data. Click "OK."
-
-
3
Click the worksheet that contains the data and select "Next." Review the columns that are being imported. Click "Next." Verify the table name and click "Finish." Access displays a confirmation messages when the records are imported. Open the table and review the additional records that have been added.
-
1
