Adding data from DB2 to Excel
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.
Posted: April 14th, 2008 under Databases, Education/training.
Which DB2 platform you’re using? I remember there is an alternative method for data loading in Excel 2007.
Comment by Eddy — April 15, 2008 @ 10:01 am
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.
Comment by Doug S — April 15, 2008 @ 10:57 am
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
Comment by Al — June 12, 2008 @ 8:56 pm