Importing AS/400 into Excel

I have seen your tip "Import file data from the AS/400 to the MS Excel document" from PAROS Junot and I do appreciate...

it. Usually when you install CA after MS Excel it takes care of the AS/400 transfer icon to appear into Excel toolbar automatically. If not your case, instead to play with the registry, you can do just the following: In Excel: From the menu- Tools->Add-ins->Browse. After that select the file: Cwbtfxla (Its typical place is: C:Program FilesIbmClient AccessShared) This will have the AS/400 data transfer icon to appear in the Excel toolbar. I very much like the 'hidden' SQL statements behind it. In fact, reporting from this place is just perfect!


This was first published in April 2001

Dig Deeper

0 comments

Oldest 

Forgot Password?

No problem! Submit your e-mail address below. We'll send you an email containing your password.

Your password has been sent to:

-ADS BY GOOGLE

SearchEnterpriseLinux

SearchDataCenter

Close