By using this site, you agree to our updated Privacy Policy and our Terms of Use. Manage your Cookies Settings.
458,208 Members | 1,467 Online
Bytes IT Community
+ Ask a Question
Need help? Post your question and get tips & solutions from a community of 458,208 IT Pros & Developers. It's quick & easy.

Link an excel cell to an access field by click

P: 1
Please if someone has the ability to answer me i would extremely grateful! how can i link (as hyperlink) a unique excel cell to an access field in order the value in access to be updated when the cell in excel changes?
Nov 10 '11 #1
Share this Question
Share on Google+
1 Reply

Expert Mod 2.5K+
P: 2,545
Short answer is you don't need to use hyperlinks at all. Access can link directly to the Excel worksheet as an external table. Changes made to the worksheet are reflected automatically when Access opens or refers to the table.

Nov 10 '11 #2

Post your reply

Sign in to post your reply or Sign up for a free account.