Import Data from Excel to Access Table

How can Samuel ensure that the information in Access will be updated automatically if the source table in Excel is changed?

A. Create a new copy of the Excel spreadsheet and import it.

B. Create a linked copy of the Excel spreadsheet.

C. Create a linked database and merge it with the Excel spreadsheet.

D. Create a new database and import the Excel spreadsheet.

Answer: C

Explanation:

Samuel can ensure that the information in Access will be updated automatically if the source table in Excel is changed by creating a linked database and merging it with the Excel spreadsheet. This way, any changes made in the source table in Excel will automatically reflect in the Access table.

By linking the database, Samuel establishes a connection between the Excel spreadsheet and the Access table, allowing for seamless data updates without manual intervention.

This method is efficient and convenient for maintaining accurate and up-to-date information in Access. It eliminates the need to repeatedly import new copies of the Excel spreadsheet.

By following this approach, Samuel can streamline the process of updating data and ensure consistency between the two databases.