Automate Access Via Excel VBA

G

GarethG

Wondering if anyone might be able to help me with this.
I have an Access File which updates my data warehouse. I then use
Excel Pivot Tables to do my work with the data. What I need is some
VBA code that executes the Access query through Excel that updates my
data warehouse. I also need to specify values that my Access query
would use such as dates and ranges i.e. AAA - ABC

I am trying to set up a pivot table that refreshes the data it Pivots
on a daily basis.


Anyone have any suggestions?:confused:
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Similar Threads

Embed the same Excel multiple times 0
Autonumber field in Excel that behaves the same as Access 0
Linking data in MS Word into Excel 5
Adding data to MS Access from csv file 0
Changing Pivot Table Value Field Labels with VBA 0
Need Help with a VBA subroutine 0
Pivot Table Mapping 1
Excel 2007 -- Dates in Pivot Tables in wrong order after refresh 1

Top