Excel to Access
I have a set of Workbooks that I use each month to compile stats etc, One is
called M76, it contains a user form with various Macros etc to maniplulate
the data,
The Data Source is and Access database Called DP2, I have a pre built query
within there that I run to get the months data,
What I want to do is insert a new user command in the excel workbook's form
which I can click and it runs off and gets the data for me,
I have managed to get excel to open Access but cannot get it to go straight
to the database in question, and then to the particular query and or macro
that runs the query?
Is it possible to do this, if so any suggestions would be gratefully received
Thanks In Advance
JTA
|