So I have searched for two days now with no luck on this topic.
Currently when a user needs to complete say "Process 1" they have to go to 5-6 different sites to pull data from them. These sites are all owned by different departments. So getting them to switch the way they run their programs to make our departments life easier is not going to happen.
I am working on a Windows Form program using access as the BE. I would like to have the program run an Excel Web Query I made on each site, then take those results and load them into the access database.
This way if SharePoint goes down we can still work with the data and also it can all be pulled at the same time displaying the results in one form.
Any ideas on how this can be done?
I thought about using RSS feeds but that would not do us any good if the program was not running and there were changes made (more than the 25 stored in the RSS feeds).
So this iqy method seems to be like the best answer. Thanks in advance for any help.