Thanks for the question, Chigor.
Asked: January 28, 2016 - 7:43 pm UTC
Last updated: January 29, 2016 - 5:37 am UTC
Version: Version 4.0.1.14
Viewed 10K+ times! This question is
You Asked
Hello Tom,
Please help me if you can.
I have written a query in my excel and now wish to connect it to my database but it does not even though i have provided the right credentials to my database.
I don't know if this is one of your areas but i was looking for know-how online and got to your website.
Do you know how I can run those query in excel and fetch records from my oracle database?
Thanks for your time.
Chigor
and Connor said...
Check out Microsoft Query, which lets you write an SQL against an ODBC datasource (hence you can access SQL Server or Oracle or anything that supports ODBC), and then use Data => From Other Sources within Excel to get it into a worksheet.
So step 1 - make sure your connection works via ODBC, ie, you should have ODBC Oracle driver under Control Panel => Admin tools => Data ODBC. You create a new data source and use the username/password/tns string as you would for (say) sqlplus or sql developer
Step 2 - use MS query to run a SQL against that ODBC source you just created
Step 3 - integrate into Excel
Hope this helps.
Is this answer out of date? If it is, please let us know via a Comment