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.

[@IsHardynafthardynaft]

Yes, it helps to find a better solution for me.
Thanks for short video 👍

[@FindEasySolution]

You are welcome

[@joyzuniga3963]

if I update excel online, should the access dbase(save in onedrive) can be automatically updated?

[@khurramabbas5163]

yes it will. He already told this in the video.

[@Z2022]

how to edit and add data in access ? thanks to help

[@muhammadarif8006]

Excellent thanks a lot Sir.🇵🇰

[@FindEasySolution]

You are welcome

[@W07043304]

how to do that vice versa ? I mean to have access source files in excel as a link ?>

[@MuhammadIbrahim-dd8hm]

Excellent

[@revision_classesTM]

👌👌👌👌👌

[@FindEasySolution]

Thank you. Please subscribe to our channel.

[@akokohjoel9854]

Pls can one link ms access to Google sheet