Download data from iSeries to Excel

15 pts.
Tags:
IBM iSeries
Microsoft Excel
How do I download data from iSeries to Excel?

Answer Wiki

Thanks. We'll let you know when a new response is added.
Send me notifications when members answer or reply to this question.

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

Discuss This Question: 5  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.

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
  • Michael Tidmarsh
    Hello lr5386, could you tell us what version of Excel you're using? I believe there's an Add-In for this but it all depends on the Excel version.
    33,310 pointsBadges:
    report
  • CharlieBrowne
    Do you want to extract the data when you have EXCEL open or do you want to create a .csv file that you can open with excel?
    41,380 pointsBadges:
    report
  • lr5386

    I am in EXCEL 2013 and I want to extract the data when I have excel open with the ADD IN or COM

    I finally got a response from IBM. see below:

    Here is the information on only able to use the Data Transfer Addin only one time in MS Excel 2013. As stated we have not tested IBM Access for Windows with Excel 2013 so technically it is not supported, but here is what we found.

    One important new feature of Excel 2013 is that it no longer supports MDI (Multiple Document Interface) and it now uses the SDI (Single Document Interface) paradigm, just following a trend that other Office applications, like Word, started a few years ago. With this new behavior, every Excel document opens a window handled by the same Excel process.

    With Excel 2013, the default you have is to create a new window within the existing Excel process. In order to force the creation of a separate instance of the Excel process, you have these options:
     
    1. From the command prompt, run EXCEL /X and you will open Excel window as a new instance. The /X command switch forces the creation of a new instance.
     
    2. Right click on the Excel Tab in Windows taskbar keeping the ALT key pressed. And without releasing the ALT key, click on “Microsoft Excel 2013” option from the context menu. Excel will ask you if you require opening Excel as a new instance. You might press YES.
    Please note you cannot use this technique to open an existing document – you have to create the new Excel process first, and then open the existing workbook from there"

    3. The other option would be to remove and add the Data Transfer addin every time you need to use in Excel 2013.


     

    15 pointsBadges:
    report
  • Splat
    Instructions for loading the Excel add-in can be found here & here.
    7,565 pointsBadges:
    report
  • dphbd1301
    lr5386 your post just led me to a good workaround for my users. It's the opening one file, then trying to open a second file (template, formatting, whatever) and trying to do a download that was failing. The "Excel.exe /x" trick works in the sense that it opens a second process, but it puts you in the same position: if you try to open a second file in that second excel process, it fails again, because the second process opens a blank workbook at first.

    What I did was make a desktop shortcut to Excel and modify it so it has the /x on the end. Then if you already have Excel running with a file open, instead of doing a file-open inside Excel to get to the second file, you can use Windows Explorer (Computer) to browse out to the second file and drag/drop it onto the modified shortcut. This opens the second file in a separate process. Downloads consistently worked for me when I did it that way.
    10 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.

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

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

Following