Upload from Excel to AS/400
Posted by Derek O'Connor on May 02, 2001 11:08 AM
Our department uploads data from excel spreadsheets to AS/400 files. Some of the uploads have numeric data in cells that needs to be uploaded into a text field on the AS/400. The data is in the format 7.6. For this to work correctly the cell in the excel spreadsheet needs to be formatted as text. The problem is that even when we use format, text on the cell it seems not to recognize this as a text field. To get it to work what I had to do was first to type in text characters 'abc' into the cell then enter the numeric data (.095). Then when I upload it gets uploaded correctly. If I not do this it uploads 0 (which is the first digit before the decimal point.