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

Excel to Access
 

Hi

One way to get data remotely from Access/Excel is to use ODBC. In short, go
to Data/Get External Data and select New Database Query. Select MSAccess
Database and browse to the required file.

Hope this helps.
Andy.

"JohnnyTheAmmer" wrote in message
...
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

Excel to Access
 

Hi

Many thanks, I did as suggested, however as the Datbase is in fact an Oracle
one and just uses an access back end I stuggled foe a while, however I
eventually go there by constructing a query through the query builder bit...

Thanks again

JTH

"Andy" wrote:

Hi

One way to get data remotely from Access/Excel is to use ODBC. In short, go
to Data/Get External Data and select New Database Query. Select MSAccess
Database and browse to the required file.

Hope this helps.
Andy.

"JohnnyTheAmmer" wrote in message
...
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