Link Access Table to Excel Data Source

Thanks! Share it with your friends!

Close

You can bring data from an excel workbook to an access database in many ways. You can copy data from an open worksheet and paste it into an Access datasheet, import a worksheet into a new or existing table, or link to a worksheet from an Access database. If you want to work with data in Access but still maintain the data in Excel, you need to link the data. This process is a bit shorter and this video shows you how.

The advantage is that it maintains a live link to the Excel worksheet. Any changes you made in the Excel data will automatically appear on the linked data in Access

Another nice thing on this video is showing some keyboard shortcuts to create data tables and to save. Please leave feedback below if you find this video useful or you have any questions.

Comments

Write a comment

*

 
  Advertisement
Skip Ad
Skip Panel
 
Skip Survey
Test
Name
Email
×
It would be awesome to hit "like" or "share" and start playing.