SHSadmin
asked on
Excel2007/AS400 data transfer crashes during download
Hi,
I installed the cwbtfxla.xll file on a user's brand new PC this morning so she can do data transfers from our AS/400 databases into an Excel spreadsheet. It seems to work on all other versions of Excel around the office, but when I try running the data transfer in Excel2007 it does not work. She is able to enter the database and lib name, but when she tries to run the transfer she gets the familiar IE app crash screen, (complete with the useless options of send/ don't send to Microsoft). PC was rebooted and restarted, data transfer was attempted again and the same thing happens. Unfortunatley, as of right now this is the only PC in the office that has Excel2007 on it, so it is not yet possible for me to test it on a different computer.
Does anyone know if there are any known bugs with this new version of Excel which will cause this? Does anyone know of any remedies or fixes? Thanks
I installed the cwbtfxla.xll file on a user's brand new PC this morning so she can do data transfers from our AS/400 databases into an Excel spreadsheet. It seems to work on all other versions of Excel around the office, but when I try running the data transfer in Excel2007 it does not work. She is able to enter the database and lib name, but when she tries to run the transfer she gets the familiar IE app crash screen, (complete with the useless options of send/ don't send to Microsoft). PC was rebooted and restarted, data transfer was attempted again and the same thing happens. Unfortunatley, as of right now this is the only PC in the office that has Excel2007 on it, so it is not yet possible for me to test it on a different computer.
Does anyone know if there are any known bugs with this new version of Excel which will cause this? Does anyone know of any remedies or fixes? Thanks
or see Altova DatabaseSpy 2007 at
http://www.altova.com/databasespy_export_import.html?gclid=CJaGrKSv040CFSY5XgodmTXBYQ
http://www.altova.com/databasespy_export_import.html?gclid=CJaGrKSv040CFSY5XgodmTXBYQ
ASKER
It turns out that the base release of ISeries Access V5.R4 is not current enough to work with Office 2007. We needed to download the most recent service pack available. As of this writing it is SI27741. It contains the Data Transfer fixes and once I installed it, it fixed the problem.
ASKER CERTIFIED SOLUTION
membership
This solution is only available to members.
To access this solution, you must be a member of Experts Exchange.
In 3 installations of Office 2007, the iSeries data transfer in Excel would crash. The solution in each case was to install Office 2007 Service Pack 1, after which the transfer data from iSeries add-in worked fine.
https://www.experts-exchange.com/questions/21782107/Transfer-Data-from-AS-400-to-Excel.html