QUERYING ACCESS
 

I have an Excel workbook that is querying an Access database, which in turn
queries an Oracle database. Is there a way to have Access automatically
update from Oracle when I open the Excel workbook?
--
Drew

Drew

Certainly there would be with code, but can you not using the Oracle ODBC
driver to get the data directly from Excel. It would then simply be a
button press to update.

If you need help with this post back

--
HTH
Nick Hodge
Microsoft MVP - Excel
Southampton, England
HIS


"Drew" wrote in message
...
I have an Excel workbook that is querying an Access database, which in turn
queries an Oracle database. Is there a way to have Access automatically
update from Oracle when I open the Excel workbook?
--
Drew

It is slightly complex, but I don't believe that I can query the data in
Excel because I am actually joining the data that I am querying from Oracle
to data that I am querying in another Oracle database. I have been using
Access because it will allow me to manually join the data there. Will the
ODBC allow you to join data from two different databases? If so then that
would solve the problem that I am having.
--
Drew


"Nick Hodge" wrote:

Drew

Certainly there would be with code, but can you not using the Oracle ODBC
driver to get the data directly from Excel. It would then simply be a
button press to update.

If you need help with this post back

--
HTH
Nick Hodge
Microsoft MVP - Excel
Southampton, England
HIS


"Drew" wrote in message
...
I have an Excel workbook that is querying an Access database, which in turn
queries an Oracle database. Is there a way to have Access automatically
update from Oracle when I open the Excel workbook?
--
Drew

You would in effect be using MSQuery in Excel (ODBC) then yes, you can join
the table there and work without access totally. You could probably even
copy the Access SQL directly into MSQuery

--
HTH
Nick Hodge
Microsoft MVP - Excel
Southampton, England
HIS


"Drew" wrote in message
...
It is slightly complex, but I don't believe that I can query the data in
Excel because I am actually joining the data that I am querying from
Oracle
to data that I am querying in another Oracle database. I have been using
Access because it will allow me to manually join the data there. Will the
ODBC allow you to join data from two different databases? If so then that
would solve the problem that I am having.
--
Drew


"Nick Hodge" wrote:

Drew

Certainly there would be with code, but can you not using the Oracle ODBC
driver to get the data directly from Excel. It would then simply be a
button press to update.

If you need help with this post back

--
HTH
Nick Hodge
Microsoft MVP - Excel
Southampton, England
HIS


"Drew" wrote in message
...
I have an Excel workbook that is querying an Access database, which in
turn
queries an Oracle database. Is there a way to have Access
automatically
update from Oracle when I open the Excel workbook?
--
Drew