The iSeries Blog

Apr 14 2008   11:14AM GMT

Adding data from DB2 to Excel



Posted by: Leah Rosin
Tags:
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.

3  Comments on this Post

 
There was an error processing your information. Please try again later.
Thanks. We'll let you know when a new response is added.
Send me notifications when other members comment.

REGISTER or login:

Forgot Password?
By submitting you agree to receive email from TechTarget and its partners. If you reside outside of the United States, you consent to having your personal data transferred to and processed in the United States. Privacy
  • Eddy
    Which DB2 platform you're using? I remember there is an alternative method for data loading in Excel 2007.
    20 pointsBadges:
    report
  • Leah Rosin
    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.
    0 pointsBadges:
    report
  • Leah Rosin
    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
    0 pointsBadges:
    report

Forgot Password

No problem! Submit your e-mail address below. We'll send you an e-mail containing your password.

Your password has been sent to: