Which Excel external data option automatically updates a table in the Access database when the Excel source file is updated?
A)import the source data into a new table
B)link to the data source by creating a linked table
C)append a copy of the records to a table
D)copy the data source from Excel

Question

Quizplus · Accepted Answer

Linking to the data source by creating a linked table allows for real-time updates between the Excel file and the Access database. Any changes made to the Excel file will automatically update the linked table in Access.

Which Excel External Data Option Automatically Updates a Table in the Access