Retrieving Data from Oracle DB into Excel File (ODBC or ODAC)
847417May 6 2013 — edited May 8 2013Dear all,
I am trying to load data from an oracle database into an excel file.
The excel file contains a form in which the user can input data for filtering purposes.
The input data will be passed into a vba function.
The vba function triggers a request to the oracle database.
The user input is used to perform a select query on the oracle database (the stored procedure should reside on oracle side, not embedded into vba).
The result of this query will be displayed in the excel file.
The Excel File resides on a different server than the Oracle database.
As I am relatively new to Oracle, I am wondering how to approach this. I read somewhere in this forum, that I would use ODBC when both the Excel File and Database reside on the same server.
I assume this means that I cannot use ODBC in my scenario? Would anyone be able to confirm this?
I came across Oracle Data Access Components (ODAC) for Windows on the Oracle Website. Is this an alternative to ODBC that would make sense in my scenario?
Your feedback would be much appreciated.
Thank you very much!
Regards,
Tobi