Excel Add-In for IBM DB2
Read, Write, and Update IBM DB2 from Excel
The IBM DB2 Excel Add-In is a powerful tool that allows you to connect with live IBM DB2 data, directly from Microsoft Excel. Use Excel to read, write, and update IBM DB2 Database data. Perfect for mass imports / exports / updates, data cleansing & de-duplication, Excel based data analysis, and more!
Install the Add-In, configure your DB2 connection, and go!
download buy now
Other Drivers
-
-
IBM Cloud Object Storage
learn more » -
IBM Informix
learn more »
Your DB2 Data, Your Way!
The Excel Add-In for IBM DB2 provides the easiest way to connect with IBM DB2 data. Users simply supply their credentials via the connection wizard to create a connection and can immediately begin working with live IBM DB2 tables of data. The Excel Add-In is completely self-contained; no additional software installation is required.
Bi-Directional Access To Live IBM DB2 Data From Excel
The Excel Add-In for IBM DB2 is integrated with the Excel toolbar and ribbon, providing direct access to live data with a single click.
Easy-To-Use, Straightforward Configuration:
- Install the Add-In
- Login with User & Password
- Select Tables
Installing the CData DB2 Excel Add-In creates a dedicated toolbar in Excel, giving users instant access to IBM DB2 data for faster data analysis and reporting. From the Excel toolbar, users can select any of the installed CData Add-Ins to configure a connection.
Select Tables and Columns
Once the data connection is configured, just specify the table and the Excel Add-In will populate a new Excel sheet with live IBM DB2 Data.
IBM DB2 Data With The Full Power of Excel
Perfect for mass imports / exports / updates, data cleansing & de-duplication, Excel based data analysis, and more!
- Modify and delete Records.
- Quickly export and backup data.
- Operate on data with Charts and Pivot Tables.
Frequent DB2 Excel Connectivity questions
Common questions about integrating DB2 with Microsoft Excel.
How do I connect DB2 to Excel?
The DB2 Excel Connector is fully integrated with the Excel toolbar and ribbon, providing direct access to live data with a single click. Installing the DB2 Excel Add-In creates a new CData data access toolbar in Excel that users can access to connect to remote data. From the Excel toolbar, users can select any of the installed CData Add-Ins to configure a connection to any data source. Once the DB2 Excel integration is configured, just select a table from DB2 and the Excel Add-In will populate a new Excel sheet with live Data.
Can I export DB2 to Excel?
Configuring a DB2 export to Excel is a thing of the past — no more downloading or copying & pasting to make sure you have the freshest data. The DB2 Add-In provides live direct connectivity to DB2 and does not require a DB2 Excel export. Simply click the Refresh button from the Excel DB2 plugin and the tool will download DB2 to excel instantly.
Is it possible to edit DB2 data from Excel?
Our integration enables live, bi-directional access to DB2 data directly from Excel. Easily pull live data into your spreadsheet, make changes, and push updates back to DB2 — all without leaving Excel. Edited cells are automatically highlighted to show differences from the source data. When ready, click the Update Rows button in the CData Add-In toolbar to sync your changes.
Is there a free trial available?
Absolutely. Free trials are available for all CData products. Your 30-day free trial of the DB2 Excel Connector will begin as soon as you have downloaded the DB2 Excel Add-In and completed the intallation process. The trial provides full, unrestricted access to all features and capabilities of the DB2 Excel Connector.
Start your trial today: DB2 Excel Add-In free download.
Popular Excel Videos:
Download the DB2 Excel Add-In
Building custom dashboards & reports that connect with live DB2 data has never been easier. Download the CData Excel Add-In for IBM DB2 now, and get connected.
Download Now
