Connecting to DB2

Connecting to DB2

The SaveToDB add-in allows connecting to DB2 tables, views, and stored procedures.

The SaveToDB add-in supports the following data providers:

  • IBM DB2 ODBC Drivers including DSN files
  • IBM OLE DB Provider for DB2
  • IBM DB2 .NET Data Provider

You can download and install IBM Data Server Client Packages at https://www.ibm.com/products.

Here is a sample of the Database Connection Wizard page where you can select the data provider:

Connecting Excel to IBM DB2 - Selecting Provider

Connecting to DB2 Databases

Use the following server name format for IBM DB2:

<Server name or IP-address>[:<Port>]

Here is a sample of the connection to the samples database on the localhost:

Connecting Excel to IBM DB2 Database

Here is a sample of the connection to the samples database on localhost port 50000:

Connecting Excel to IBM DB2 Database

This website is using cookies. By continuing to browse, you give us your consent to our use of cookies as explained in our Cookie Policy.