data transfer from excel to AS400 text to Char format
Posted on 2009-03-30
Hello all. I am trying to upload data (append) from excel to my AS400 db file (running V5R4) and I am getting an error on a cell that is formated (in excel 2007) as text but contains 0039. No leading ' . It is a part number but on the AS400 that field is charactor field not numeric. This db file has 33 columns (fileds) and I downloaded the file first into excel so I could have a sample record to use. I deleted all the records except my sample (Row2). I then added in about 5000 part numbers (starting in row 3, column 2), and their price in column D. All the other fields I copied to the other records from my example so all fields contain required data. When I try to upload (append) it comes back with "CWBTF0005 Data in this filed (row 3 column 2) is incorrect or does not match the PC data type. Nothing at al from the excel sheet is actually uploading. The column with the part number (column 2) is all formatted as text in excel and there is no ' in front of any of the numbers. Help? I notice when downloading into excel we seem to have options to control the format coming down but not going up to match? Is there another setting? Any tips or hints would be greatly appreciated. I was able to do this successfully with about 20 other files in January that ironically contain the same part number (0039) but for life of mean I can't think what I missed.