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.

Question

Cristal Ellis

27 October, 15:06

+4

Answers (1)

Know the Answer?

Alonzo Kirk · Answer 1

Create a linked database and merge it with the excel spreadsheet is what I think the answer is ...

Good luck!