If you link an Excel workbook to an Access database, you can edit the linked table in Access.

Name: If you link an Excel workbook to an Access database, you can edit the linked table in Access.
Brand: Quizplus
Rating: 5.0 (43 reviews)

Question

Quizplus · Accepted Answer

When you link an Excel workbook to an Access database, you can view and query the data in Access, but you cannot edit the linked table directly in Access. Changes must be made in the Excel workbook.

If You Link an Excel Workbook to an Access Database