Transfer Data to iSeries from Excel

pts.
Tags:
PC/Windows Connectivity
Visual Basic
I have some VB code that reformats some data in an Excel workbook. The last step of my code needs to transfer a range of cell to an existing file on the iSeries using an existing data tranfer definition. Is there a way to invoke the dialog box that supports the upload of data to the iSeries from within VB? Normally I would teach the user how to use the menu but keystrokes seem important here. I am running excel 2002 SP3 under W2K SP4. Our Client Access version is V5R3. Thanks in advance.

Answer Wiki

Thanks. We'll let you know when a new response is added.

Greg,

IBM Client Access has a COM object library (Client Access Object Library – CWBAUTSV.tlb) that you can reference in your project to perform operations on the iSeries. There is also a cwbctrl.tlb type library that you can check out. Between these two, you should have the ability to accomplish your task.

Hope this helps.

Charles

Discuss This Question:  

 
There was an error processing your information. Please try again later.
Thanks. We'll let you know when a new response is added.
Send me notifications when members answer or reply to this question.

REGISTER or login:

Forgot Password?
By submitting you agree to receive email from TechTarget and its partners. If you reside outside of the United States, you consent to having your personal data transferred to and processed in the United States. Privacy

Forgot Password

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

Your password has been sent to:

To follow this tag...

There was an error processing your information. Please try again later.

REGISTER or login:

Forgot Password?
By submitting you agree to receive email from TechTarget and its partners. If you reside outside of the United States, you consent to having your personal data transferred to and processed in the United States. Privacy

Thanks! We'll email you when relevant content is added and updated.

Following