It sounds as you will need to use a VBA program (macro) to coordinate sending data to the AS/400. You can still use some facilities of Client Access. The VB add-ins are most helpful. Dave
Unconfigured Ad Widget
Collapse
Announcement
Collapse
No announcement yet.
Upload excel data to AS400 from workbook with multiple sheets
Collapse
X
-
Upload excel data to AS400 from workbook with multiple sheets
How can I upload an Excel workbook with multiple sheets to an AS400? Also the spreadsheets are using merged fields (which seems to eliminate Client Access) and the data is arranged in multiple pivot tables within each sheet. Any and all help is appreciated.
Comment