Used Oracle Discoverer to extract needed data from tables
and export them to excel. Then manipulated the data in
excel using macros to give desired results and reports.
Is there any way to mechanize the process further so user
could run the whole job? Could I create a macro in the
excel workbook to use ODBC to run a query on the oracle
tables and pull the data in and then continue the
processing that is currently being done? Have never used
ODBC - if this is possible can you point me toward a
learning source for novices? I hope this makes sense and
is understandable. Thanks.

This might be a help for getting data to and from Excel and Access using
ODBC. It should be much the same for Oracle. It includes examples of using
variables in SQL queries.
http://www.bygsoftware.com/examples/sql.html

Or you can get there from the "Excel with Access Databases" section on page:
http://www.bygsoftware.com/examples/examples.htm

It demonstrates how to use SQL in Excel's VBA to:

* create a database,
* create a table and add data to it,
* select data from a table,
* delete a table,
* delete a database.

You can also download the demonstration file called "excelsql.zip".

The code is open and commented.


--

Regards
Andy Wiggins
www.BygSoftware.com
Home of "Save and BackUp",
"The Excel Auditor" and "Byg Tools for VBA"


"pmz" wrote in message
...
Used Oracle Discoverer to extract needed data from tables
and export them to excel. Then manipulated the data in
excel using macros to give desired results and reports.
Is there any way to mechanize the process further so user
could run the whole job? Could I create a macro in the
excel workbook to use ODBC to run a query on the oracle
tables and pull the data in and then continue the
processing that is currently being done? Have never used
ODBC - if this is possible can you point me toward a
learning source for novices? I hope this makes sense and
is understandable. Thanks.