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

Shaniya Strong

5 November, 12:34

+1

Answers (1)

Know the Answer?

Tamara Stein · Answer 1

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

Good luck!