Avatar of Chris Pfeiffer
Chris Pfeiffer
Flag for Japan asked on

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.
.NET ProgrammingVisual Basic.NETMicrosoft SharePointMicrosoft ExcelMicrosoft Access

Avatar of undefined
Last Comment
Chris Pfeiffer

8/22/2022 - Mon

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.
Chris Pfeiffer


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?

Log in or sign up to see answer
Become an EE member today7-DAY FREE TRIAL
Members can start a 7-Day Free trial then enjoy unlimited access to the platform
Sign up - Free for 7 days
Learn why we charge membership fees
We get it - no one likes a content blocker. Take one extra minute and find out why we block content.
Not exactly the question you had in mind?
Sign up for an EE membership and get your own personalized solution. With an EE membership, you can ask unlimited troubleshooting, research, or opinion questions.
ask a question
Chris Pfeiffer

This did not work but for now I have gone a different direction.  I will award points to Aikimark for his efforts.  Thanks!
Experts Exchange is like having an extremely knowledgeable team sitting and waiting for your call. Couldn't do my job half as well as I do without it!
James Murphy