We help IT Professionals succeed at work.
Get Started

Read an Excel Web Query into an Access Database

Last Modified: 2014-06-07
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.
Watch Question
Social distance; Wear a mask; Get vaccinated
Top Expert 2014
This problem has been solved!
Unlock 1 Answer and 4 Comments.
See Answer
Why Experts Exchange?

Experts Exchange always has the answer, or at the least points me in the correct direction! It is like having another employee that is extremely experienced.

Jim Murphy
Programmer at Smart IT Solutions

When asked, what has been your best career decision?

Deciding to stick with EE.

Mohamed Asif
Technical Department Head

Being involved with EE helped me to grow personally and professionally.

Carl Webster
CTP, Sr Infrastructure Consultant
Ask ANY Question

Connect with Certified Experts to gain insight and support on specific technology challenges including:

  • Troubleshooting
  • Research
  • Professional Opinions
Did You Know?

We've partnered with two important charities to provide clean water and computer science education to those who need it most. READ MORE