Read an Excel Web Query into an Access Database
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.
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.
aikimark
Do you have to use Excel? It would seem simpler to me if you made direct queries to the web sites, parse the results and then push the data to the Access database.
ASKER
Aikimark,
I have seen where you can query with LINQ to SharePoint 2010 but we are not using 2010 yet. If you know of a way to do this with 2007 I am up for suggestions. I assume you mean pulling from the list correct?
I have seen where you can query with LINQ to SharePoint 2010 but we are not using 2010 yet. If you know of a way to do this with 2007 I am up for suggestions. I assume you mean pulling from the list correct?
ASKER CERTIFIED SOLUTION
membership
This solution is only available to members.
To access this solution, you must be a member of Experts Exchange.
ASKER
This did not work but for now I have gone a different direction. I will award points to Aikimark for his efforts. Thanks!