Kick off Access Queries From Excel

[bconner]

I have a series of Access Databases that I run reports out of each month. I would like to set up an excel worksheet from which I could kickoff all of the queries, is this possible and if so how? I don't want to return the results back to excel, I simply want to kick them off using a button in excel. Also some of the queries require criteria is it possible to pass the value of an excel cell to an access query criteria? If so how?

Any help is greatly appreciated.

 

[hgus393]

Hi,

Set up some macros in access that does all the uppdating then use:

Sub XLUpdate()
Dim B As Object
Set B = CreateObject("Access.Application")
B.Visible = False
B.OpenCurrentDatabase ("Path of database")
B.DoCmd.RunMacro "Macro name"
End Sub

Bob

 

[bconner]

Excellent, thank you Bob!