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.