How to Link Microsoft Access to a Microsoft Excel Workbook to Read Live Data without Importing

In this video, I will show you how to have Microsoft Access create a linked table to a Microsoft Excel worksheet. This will allow you to read data from the sheet and is continuously updated in real-time when changes are made to that sheet.

Ronnie from Olympia, Washington (a Platinum Member) asks: My sales department keeps a spreadsheet on the network that contains all of the new customers for the month. Is there any way I can open that sheet up from Access to view their data? I'd like to query that against my existing data I have in Access, but I don't want to have to keep importing their sheet over and over again.

Silver Members and up get access to an Extended Cut of this video. Members will see how to get a value from a specific cell on a specific sheet in a specific workbook without linking to the sheet as a table. We will use VBA and automation to get the value of whatever cell you want (even named cells).

Brent from Tracy, California (a Gold Member) asks: Is it possible to link to one cell in an Excel workbook which has multiple sheets? For example, the first sheet we will call TAB1 and the second TAB2. I would like to link to a value that is in cell B6 on TAB2. Would this be possible?

MEMBERS VIDEO:

BECOME A MEMBER:

LEARN MORE:

LINKS:

COURSES:

FREE TEMPLATE DOWNLOADS:

ADDITIONAL RESOURCES:

KEYWORDS:
microsoft access, ms access, ms access tutorial, #msaccess, #microsoftaccess, #help, #howto, #tutorial, #learn, #lesson, #training, #database, link access to excel, Can Access and Excel work together, link access to excel read/write, access write to excel sheet, How do you link Excel spreadsheets in Access, How do I get Excel to automatically update Access database, link to data in an Excel workbook, Linking Access Database Tables To An Excel Workbook, How to Link an Excel Spreadsheet to MS Access

QUESTIONS:
Please feel free to post your questions or comments below. Thanks.

[akokohjoel]

The MS ACCESS tutor of our generation. Keep the good job

[stanTrX]

Thanks for the videos Richard.they are very helpful.

[mimosavlog]

I like MS Access so much, thank for your video!

[YamsBont]

6:10 I see what you did there!
Nice presentation of the bassics I must say! Nothing too rushed!

[rollerchoaster]

Every time a nice video to do something in access. The problem with this is that when there is somebody working in the excel Access can't read the data, so hope there is a way that access only do a read only on the excel so that the excel is still usable, but until now didn't find it.

[shobha.g.sshankarappa]

Excellent video, please make video on how to filter continuous form with filtering criteria in 2 or 3 columns of drop-down lists and with two date range please.

Thanks for your videos, your videos are excellent..

[rtv]

Thank you for your great explenations! I love your work, it is a big inspiration. Your little jokes and Star Trek references put a smile on my face every time. I have a question. In your vid. you show that you are able to edit the Excel File with MS Excel (while Acces is open), then the changes become visible in your Acces database. In my database, I cannot make changes in the Excel file with MS Excel, when Acces is opened. Then I can only open the Excel file in read only mode. When I close Acces, then I can make changes in the excel file with MS Excel. When I re-open Acces those chages become visible. I cannot figure out why my acces behaviour is different than in your vid.

[JosephZielinski-cuun]

I am trying to link my Excel spreadsheet to an existing database. When doing so I only get one record imported to Excel from Access.. Please help!

[venkatyalamati]

Sir, plz make a video on how to get SAP table data into MS Access

[giovanniguarino]

But is possible to mantain the excel cell format in the access table and next to the access form?

[dnnla]

is there a way to continue the linked table in the next excel sheet in case that the original one is full? thank you in advance

[mjr]

I have a source data like this in excel. What I would like to do is create a table with the source records (dont want to change the source) but have additional columns to add to the data within access. Is there a way to do that?

[ultrasonicbowlingproducts]

I have a 21k record spreadsheet, which includes a boolean field. When I use LINKED excel to access, it breaks and fills my data with '#ref' error. is it possible to link to boolean?

[linawalker]

How can I link an Access query to an Excel spreadsheet?

[khurramliaquat]

How to link a password protected access database to Excel????