You are here Excel connect to external database Excel Connect to Oracle Database by Add-in A-Tools - Create DBKEY

Excel Connect to Oracle Database by Add-in A-Tools - Create DBKEY

Oracle is a database server, it support risk function to query data. In Excel you can connect to Oracle Database by Add-in A-Tools. Please do step by step:

1. Install Oracle Client here

+ For Office 32-bit

https://uofi.app.box.com/s/uq7ot6guyc8wey7nbvfxgt0eeixjbwv5

+ For Office 64-bit

https://uofi.app.box.com/s/93svfdpnh6lzmxq8atuohi9levyhuw0k

Download and install it very easy! "Next" to Next ... Finish.
2. Install Add-in A-Tools
 
3. Open Microsoft Excel, go to menu "A-Tools".
+ Click on "DBKEY", "Add", select "ODBC/ConnectionString" from menu.
 
- Select Driver with Provider name "ODBC Drivers", click button "Next"
 
- Click "Use Connection String" and then click on button "Build"
 
- Click tab "Machine Data Source" and then click on button "New"
 
- Select Driver with name ":Oracle in XE" or any name with "Oracle" (do not choise "Microsoft ODBC Oracle")
 
Demo Oracle database on our server "bluesofts.net" you can select your server if you are ready.
User ID: system
Password: admin
 
Video:
+ Create DBKEY with name "oracle" (you can create name by optional)
4. Query data from Oracle database in our server (bluesofts.net)
Type formula on worksheet
 
=bs_Sql("SELECT * FROM data","dbkey=oracle")
 
Video help connect to Oracle and create report Excel having grouping as subtotal