Question Locked

Web Queries for MS Access

0 helpful
3 replies
Closed to new repliesThis discussion is closed. It stays readable, but it takes no new replies.
I have a xls that I use to evaluate individual stocks and would like to use access to store the results so that I can compare todays analysis with prior ones. Is there any way for me to recreate the sheets in access and still use the web query function to capture web data?

3 replies

by thecarloscastro

All the controls for refreshing the web query are in Excel. As far as I can tell, there is no way to make Access trigger Excel to refresh the Web query and see how the data has changed. 'les@...', I am also looking for a way to dynamically update data from the web in MS Access. Someone let me know when they figure it out please! :D

This discussion is closed to new replies.