|
The easiest way to do this is to have the users save the files to a shared folder in a fixed format and pick them up on the iSeries 400 side by doing a CPYFRMPCD to a flat file. You can then process that flat file. If you want to use VB, there are examples of how to handle the spreadsheets by column and row included with iSeries file using an SQL statement in VB. There are "SELECT" examples in the samples directory under Program Files/IBM/Client Access/Toolkit/Samples directory. Change the "SELECT" example to an "INSERT". You can also search here on Search400.com for VB examples.
==================================
MORE INFORMATION ON THIS TOPIC
==================================
The Best Web Links: tips, tutorials and more.
Ask your systems management questions--or help out your peers by answering them--in our live discussion forums.
|
