Hi,
I'm trying to connect to PL/SQL and get view result in excel. I do not have ODBC set up due to some issue. Is there any other way to connect to PL/SQL in excel.
Thanks in advance
Hi,
I'm trying to connect to PL/SQL and get view result in excel. I do not have ODBC set up due to some issue. Is there any other way to connect to PL/SQL in excel.
Thanks in advance
Hi there,
It should be quire possible using ADO (or DAO presumably, but I stick to the newer ADO). I have no experience with Oracle, though in principle aside from the connection string, it should be similar to what I do with mySQL and Access databases. This link may help get you started: https://stackoverflow.com/questions/...nsde-excel-vba
Please help by:
Marking threads as closed once your issue is resolved. How? The Thread Tools at the top
Any reputation (*) points appreciated. Not just by me, but by all those helping, so if you found someone's input useful, please take a second to click the * at the bottom left to let them know
There are 10 kinds of people in this world... those who understand binary, and those who don't.
I tried to use ADODB with Provider as 'ORAOLEDB.ORACLE' which gave 'Run time error 3706'.
I do not have Oracle client installed in my system. Please let me know if we can use ORAOLEDB with out having oracle client installed.
Else, do we have any other method to retrieve data from oracle table in excel
Thanks in advance
You don't need the Oracle client, but will need to find the Oracle ODBC driver. The version may well depend on the Oracle version being used, so I'm afraid that I can't provide a link without knowing your full setup, but googling oracle odbc driver should give you various results, including Oracle.com
Hi,
I do not have Oracle ODBC driver as well. I use Oracle SQL developer version 4.1.0 to run queries.
I'm looking for an option to connect to sql developer from excel and retrieve result.
I could not create ODBC connection as it gave me error as 'Oracle tm components are missing'
I realize you don't have the ODBC driver BMD4, but you should be able to download that through the Oracle website? It is usually a resource readily available (and free).
However, you may also have to talk to your IT department, very often a password and username are required to log into these databases, perhaps you already have that info if you are running queries through another tool.
There are currently 1 users browsing this thread. (0 members and 1 guests)
Bookmarks