There are many third-party packages that provide IBM I to Excel export and import capability. IBM’s strategic direction for Excel 2013 and Office 365 compatibility is to use the data transfer capabilities in its IBM i Access Client Solutions package.
#Client access as400 install windows#
4. IBM’s strategic direction for Excel data exchange is to use an alternative to IBM i Access for Windows data transfer. As a result, IBM is no longer supporting the data transfer add-in for Excel 2013 and Office 365. IBM is not rewriting the Excel data transfer that comes with IBM i Access for Windows 7.1 (based on the V6R1 version) and the add-in will not be rewritten for future versions of Excel. Details can be found at the IBM i Access for Windows Data Transfer and Excel 2013 Website. IBM has encountered compatibility issues when launching the Data Transfer add-in in Excel 2013 and Office 365 (which also uses Excel 2013). The Excel Data Transfer Add-in is not supported with Excel 2013 and Office 365. IBM provides instructions for modifying an Excel data transfer set-up at its COM-Based Microsoft Excel Data Transfer Add-In for V6R1 and beyond Web site. The result is you have to swap out components of your Excel data transfer add-in when 1) you’re migrating users from an older version of Excel to Excel 2007 or 2010 or 2) you’re moving up to IBM i Access for Windows V6R1 or V7R1. The Excel SDK version was not compatible with Excel 2007.
#Client access as400 install software#
Starting with V6R1 System i Access for Windows, IBM phased out using the Excel Software Development Kit (Excel SDK) for the Excel data transfer add-in and replaced it with a new add-in based on Microsoft’s Component Object Model (COM). Over the last two releases, IBM i Access for Windows users have had to modify their client setups to make the Excel data transfer add-in work with Excel 2007 and Excel 2010. 2. IBM i Access for Windows Excel data transfer capabilities need tweaking when changing Excel or IBM i Access versions. It is recommending customers start using an alternative to the old Excel data transfer add-in for Excel 2013 and beyond compatibility. But IBM is changing its strategic direction for IBM I to Excel data transfer. IBM i Access for Windows and its predecessor products have provided Excel import and export capability for companies running AS400, iSeries or Power Systems with IBM i for years, primarily through the Excel data transfer add-in that comes with the product. IBM i Access for Windows has traditionally provided capabilities to export and import DB2 UDB data to Excel spreadsheets…but that’s changing. Here are five things you need to know about the IBM i-to-Excel data transfer feature and what your shop may need to change in the near future.ġ. IBM is no longer supporting the data transfer add-in, and IBM’s stated direction is for users to run another product for Excel 2013 data transfer and future Excel integration. Recent versions of the Excel data transfer add-in aren’t compatible with Microsoft Excel 2013. There are changes coming if your shop is running an AS400 or iSeries or Power System with IBM i and uses the Excel data transfer function that comes with IBM i Access for Windows (AS400, iSeries) .