How to connect to Oracle database from Microsoft Excel | Import data into Excel from database tables
HTML-код
- Опубликовано: 27 дек 2022
- You can use Microsoft Excel to access data from a wide variety of external data sources. In this step-by-step tutorial, you learn how to connect Excel to an Oracle database. You can then import the data into Excel and explore it for further analysis or use it for creating reports and charts. Note, this tutorial doesn't cover how to create a database in Excel. This video only demonstrates how to configure an Excel Workbook to download or retrieve data from an Oracle database table.
Table of Content:
01:10 - Downloading Oracle Data Access Components (ODAC) for Microsoft Excel
02:50 - Installing ODAC
04:05 - Connecting Excel to Oracle
06:00 - Getting data from the database into Excel using SQL query
08:10 - Accessing database tables from Excel
09:09 - Changing or removing a data connection
10:10 - Uninstall ODAC
Facebook
/ oracle.tutorials
Very clear instructions which worked. Thanks!
Thank you Broo
Thanks it really worked however in my case what was missing is Servername/SID. I tried using this but I was getting some listener error. Then I added port name and it looked likeServername:1660/SID (1660 was the port name) and it worked like a charm
So i don't have the option to add "From Oracle Database" ?
You skipped the video and did not view it completely
@@oracle_professor No i didn't. You just go to the data, then under the db's, yours has oracle listed, mine doesnt.
@@Pr0x1mo I've got the Ofice 2021.