Transfer Data to iSeries from Excel
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.
Software/Hardware used:
Software/Hardware used:
ASKED:
September 26, 2006 2:24 PM
UPDATED:
September 26, 2006 2:51 PM
RELATED QUESTIONS
- Transfer Data from iSeries to Excel
- Direct an SQL statement
- AS400 Transfer to Excel with a Locked Cell
- Add In function in Excel 2010 to download file from iSeries v7.1 exceeding limit, is there something we need to do to up the limit of records from 64K
- Automatically Transfering from Excel to iSeries
Answer Wiki:
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
To see all answers submitted to the Answer Wiki: View Answer History.
RSS - Discussions Help
Discuss This Question:
_ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _
