Question

Samuel needs to import information from Excel to an Access table, but he wants to ensure that if the source table is changed, the information in Access will be updated automatically. What should he do?

Create a new copy of the Excel spreadsheet and import it.
Create a linked copy of the Excel spreadsheet.
Create a linked database and merge it with the Excel spreadsheet.
Create a new database and import the Excel spreadsheet.

Answer 1

Create a linked copy of the Excel spreadsheet.

Linking (not importing) creates a live connection so changes in the Excel source are reflected in the Access table. Importing makes a static copy that won't update automatically.