Connecting to Oracle Database
The SaveToDB add-in allows connecting to Oracle Database tables, views, stored procedures, and table functions.
The SaveToDB add-in supports the following data providers:
- Oracle OLE DB Provider
- Oracle ODBC drivers, including DSN files
- Oracle Data Provider for .NET Framework
The add-in ships the .NET data provider. So, you can use it from the box.
You can download and install Oracle Database Client components at
Here is a sample of the Database Connection Wizard page where you can select the data provider:
Connecting to Oracle Databases
Use the following server name format for Oracle:
[<Server name or IP-address>[:<Port>]/]<Service name>
Here is a sample of the connection to the service named XE on localhost port 1521:
Microsoft Excel does not support connections as SYSDBA or SYSOPER. You can use logon as SYSTEM.
You can use a service name configured in the tnsnames.ora file on the local machine with OLE DB providers and ODBC drivers.
Here is a sample of the connection to the service named XE: