Oracle Data Pull to Excel spreadsheets

[toddalan]

Trying to figure out how I can create a macro in excel to search the database for records in two different tables and based on the dates pull in the required information the the user wishes to see. I am doing this to a configuration tool that engineers use to create price models for customers, Please help me I am a newbie on macros, also will provide further information if anyone can get me started.

Thank you sooo much in advanced
Todd

 

[meker]

From Bill Gates:

"You can specify an external data source by using Microsoft Query. Microsoft Query is an optional feature for Microsoft Excel. If you chose the Typical installation option during Setup, Microsoft Query is not installed on your computer."

If you go this route, search for ODBC using Excel Help and you will find a pretty good explaination on how to proceed down your path.

That said, you might be better off using Microsoft Access to access the data. It will be a bit more flexible in use and your users would not have direct access to the data - which can be a bad thing.

Mark