Link Excel Cell to Access - Microsoft Access Forum


	Back to Access Forum Comments List

Upload Images @Reply Bookmark Link Email Next Unseen

Link Excel Cell to Access

Brent Rinehart

5 years ago

Is there a way to link to a excel spread sheet and bring in a value from one cell in a workbook that has multiple spreadsheets in it? Maybe Vlookup? Im not great with Excel colleage would like to know if this is possible to bring data that gets updated in an excel file that we can bring into my database so that the data doesn't have to be entered twice.

	Brent Rinehart OP @Reply 5 years ago
Is it possible to link to one cell in an excel workbook which has multiple spreadsheets? for example workbook has 2 spreadsheets first tab we will call TAB1 and the second TAB2 and I would like to link to a value that is in cell B6 on TAB2. would this be possiable.

	Richard Rost @Reply 5 years ago
You literally just want to read in one cell? Is it the same cell all the time, like A5?

	Richard Rost @Reply 5 years ago
I'm sure it's possible to GET that value, but you can't link to it in a traditional sense. You would need some automation. I'll put something together for you.

	Richard Rost @Reply 5 years ago
This is perfect... I have another question from a member asking how to link to Excel, so I'll combine them. Your question will be in the extended cut. Look for it later today.

	Richard Rost @Reply 5 years ago
Here you go, Brent. Enjoy: Link to Excel

	Brent Rinehart OP @Reply 5 years ago
This is gold, nailed it video was exactly what I was looking for you couldn't have done a better job Thank you Richard

	Richard Rost @Reply 5 years ago
Sweet. Glad you like it. I have a LOT more coming with Automation in the Developer lessons... controlling Word, PowerPoint, etc.

	Brent Rinehart OP @Reply 5 years ago
Sounds great the more that can be automated preventing users having to enter data twice will allow for data to be more accurate and they wont complain about having to enter data multiple times as well.

	Richard Rost @Reply 5 years ago
Indeed. :)

This thread is now CLOSED. If you wish to comment, start a NEW discussion in Access Forum.

Next Unseen

New Feature: Comment Live View