Want to protect your cyber security and still get fast solutions? Ask a secure question today.Go Premium


Excel2007/AS400 data transfer crashes during download

Posted on 2007-07-31
Medium Priority
Last Modified: 2013-12-06

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
Question by:SHSadmin
LVL 10

Expert Comment

ID: 19606082
LVL 10

Expert Comment

ID: 19606099

Author Comment

ID: 19619963
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.

Accepted Solution

Computer101 earned 0 total points
ID: 20106465
PAQed with points refunded (125)

EE Admin

Expert Comment

ID: 23978921
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.

Featured Post

NEW Veeam Backup for Microsoft Office 365 1.5

With Office 365, it’s your data and your responsibility to protect it. NEW Veeam Backup for Microsoft Office 365 eliminates the risk of losing access to your Office 365 data.

Question has a verified solution.

If you are experiencing a similar issue, please ask a related question

Microsoft's Excel has many features that most people will never need nor take advantage of.  Conditional formatting is one feature that you may find a necessity once you start using it.
Instead of error trapping or hard-coding for non-updateable fields when using QODBC, let VBA automatically disable them when forms open. This way, users can view but not change the data. Part 1 explained how to use schema tables to do this. Part 2 h…
Many functions in Excel can make decisions. The most simple of these is the IF function: it returns a value depending on whether a condition you describe is true or false. Once you get the hang of using the IF function, you will find it easier to us…
This lesson discusses how to use a Mainform + Subforms in Microsoft Access to find and enter data for payments on orders. The sample data comes from a custom shop that builds and sells movable storage structures that are delivered to your property. …

580 members asked questions and received personalized solutions in the past 7 days.

Join the community of 500,000 technology professionals and ask your questions.

Join & Ask a Question