DB2 Add-in for Excel

8225 pts.
Tags:
AS/400 DB2
Excel add-in
I am looking for info on setting up IBM's DB2 add-in for Excel. This tool allows data to be imported into Excel directly from an IBM i file using SQL statements. I am having a devil of a time getting this configured. 

Can anyone share their setup of the DB2 add-in?


Software/Hardware used:
IBM i; Excel
1

Answer Wiki

Thanks. We'll let you know when a new response is added.

A lot depends on what version of Excel. When I had Excel 2010, it was no problem. New computer now with Excel 2016.. The add-on is an issue because you can’t find a compatible one to install. I can’t remember the article I read, but one of the 2 sides decided to drop the add-on support. Now I have to go into the Client Access data transfer utility. I just use the SQL portion to create an output file, mainly CSV I tend to have better luck with.. That was the only option I fond so far.

Discuss This Question: 6  Replies

 
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 members answer or reply to this question.
  • azohawk
    File Transfer will allow you to do SQL type statements (build each statement individually) and transfer to excel. This what I typically use. Available in both Client Access and the supported Access Client Solutions for i.
    4,055 pointsBadges:
    report
  • TheRealRaven
    Essentially impossible to answer without knowing the version of Excel, the OS it runs on, the version of IBM i Access and the IBM i OS version. Please provide enough detail for an answer.
    35,070 pointsBadges:
    report
  • WoodEngineer
    Thank you for the repsonses.  In this case, the end user has no knowledge of the IBM i and requires everything to run in a Microsoft environment even though needing to import data from the IBM i.

    I have a hunch that the primary problem is creating a proper config file for the DB2 add-in.

    Have anyone seen a user manual for DB2 CLI?
    8,225 pointsBadges:
    report
  • azohawk

    We use VB in Excel to pull data from the Power System. The user fills in a few paramaters and presses a button on the page.  This calls a procedure on the Power System and prepares the data, the data is then downloaded to a page on the spreadsheet.

    Have also done some extraction of data using the Microsoft query tool. 

    Either way, IT sets everything up so all they have to do is put in parms and press a button to  download the data.

    4,055 pointsBadges:
    report
  • WoodEngineer
    Thank you for the suggestions, Azohawk.

    When technique (tool) do you use to download to a page on the spreadsheet?
    8,225 pointsBadges:
    report
  • azohawk
    odbc
    4,055 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:

To follow this tag...

There was an error processing your information. Please try again later.

Thanks! We'll email you when relevant content is added and updated.

Following

Share this item with your network: