![]() ![]() 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. 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) . ![]()
0 Comments
Leave a Reply. |
AuthorWrite something about yourself. No need to be fancy, just an overview. Archives
February 2023
Categories |