uploading an excel spreadsheet to the as/400
I've seen a developer with an Excel spreadsheet on the iseries server, how do I upload an Excel spreadsheet to the iseries and populate it with data so I can then download the finished product to my PC?
ASKED:
May 5, 2008 9:23 PM GMT
UPDATED:
August 18, 2010 9:38:25 AM GMT
RELATED QUESTIONS
- Outlook 2007 excel attachments
- Direct an SQL statement
- uploading a excel file to ifs file on as400
- Iseries Access data transfer
- Display External File Properties in Excel
- Matching data in Excel
- Existing macros attached to custom toolbar buttons
- Program Management Control
- Office 2007 labels using an Excel worksheet
- Excel compact or compress utility?
Answer Wiki:
The easiest way is to use the iSeries Access plugin for Excel. Click "Data", then "Transfer data to iSeries". and follow the wizard.
3,000 pts.
To see other answers submitted to the Answer Wiki View Answer History.
