Home > IT Blogs > The iSeries Blog > Adding data from DB2 to Excel
>>VIEW ALL POSTS  

The iSeries Blog

«
»
Apr 14 2008   11:14AM GMT

Adding data from DB2 to Excel



Posted by: Leah Rosin
Databases, Education/training

On Friday, I saw an unanswered iSeries-related question posted to IT Knowledge Exchange, and thought I’d shoot the question straight to one of our experts at Search400 to see if they could help.

Ljjk122 posted this question on ITKE: I want to add data from a DB2 file to an Excel template that has a header row and totals certain columns without overwriting the header row or the totals.

I sent the question to Kent Milligan at IBM, who said:
It’s not clear what mechanism you’re using to get the DB2 data into the Excel spreadsheet. If you’ve purchased the iSeries Access Data Transfer, there is a solution. The iSeries Access Data Transfer Excel Add-in has the ability to download data to a user-specified range of cells of a spreadsheet, overwriting only the data within the selected range.

If you don’t have a license for the iSeries Access Data Transfer solution, then you may also want to consider evaluating DB2 Web Query, which offers excellent integration with Excel.

We encourage anyone with an iSeries question to submit it to Search400′s Ask the Experts, where all of our experts are available to answer your questions.

  Bookmark and Share     Comment     RSS Feed     Email a friend

Comment on this Post

Leave a comment:

Eddy  |   Apr 15, 2008  10:01 AM (GMT)

Which DB2 platform you’re using? I remember there is an alternative method for data loading in Excel 2007.


 

Doug S  |   Apr 15, 2008  10:57 AM (GMT)

We had a similar challenge from the finance department. We developed an Excel function using VB and ASNA to pull data directly from DB2 files on our System i. It works great. Each cell contians the range(s) of accounts whose total should appear in that cell. Once the data lands in the cell it can be used just like the data in any other cells. This also gives us very precise control of what data is pulled into the spreadsheet and where it appears.


 

Al  |   Jun 12, 2008  8:56 PM (GMT)

Hello,

A simple way to pull data from DB2 into an excel worksheet is to use the freeware SQL Excel Add-in. You can see more information about the add-in here – http://www.sqlexcel.net

It is a genuine freeware and it works fine with DB2 and other other data source for which you have ODBC drivers – SQL Server, Oracle, Sybase etc..
Thanks, Al