How to Link an Excel Spreadsheet to MS Access - Office 365

This video explains how you can link an excel worksheet or named range (range of cells in a worksheet) to MS Access. Access creates a table called Linked table and allows you to view the data from the excel spreadsheet. Any changes you make to the data in excel will be reflected in the linked table in MS Access. You can only view the data in MS Access through linked table but can't modify the data or structure of the table.