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

Linking to an Excel File

100+
P: 119
hi there,

This should be a very quick question to resolve. I have linked to an excel spreadsheet from Access for the first time. My understanding was that whenever a change occurs in the spreadsheet the change should be reflected in Access more or less straight away.

However, I find that the only way to update the data in Access is to save the Excel sheet and then 'refresh all' in Access. Is this correct? I need live data in Access, and so having to save a spreadsheet every few minutes isn't really ideal.

Thanks,
Nov 30 '06 #1
Share this Question
Share on Google+
2 Replies


NeoPa
Expert Mod 15k+
P: 31,660
hi there,

This should be a very quick question to resolve. I have linked to an excel spreadsheet from Access for the first time. My understanding was that whenever a change occurs in the spreadsheet the change should be reflected in Access more or less straight away.

However, I find that the only way to update the data in Access is to save the Excel sheet and then 'refresh all' in Access. Is this correct? I need live data in Access, and so having to save a spreadsheet every few minutes isn't really ideal.

Thanks,
Bear in mind that Access links to an Excel file.
When you edit a spreadsheet in Excel you don't make any changes to the file until you save it, so nothing will be accessible to Access at that stage.
I would guess from your remarks that Access treats an Excel link like a Snapshot query rather than like a Dynaset.
You would need to Requery to get data updated by a third party (IE. You editing the file with Excel).
Essentially you can't have what you need. That's not how it's been programmed :(.
Dec 1 '06 #2

100+
P: 119
Thanks for the reply. I guess I'll have to put up with saving the sheet when I need updated data.
Dec 1 '06 #3

Post your reply

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