Pete: We run into this when we have users key data into a spread sheet & we then try to upload it. The transfer should tell you which record is causing the problem, we just re-key the data in that record. Usually it is a numeric that thinks it has alpha data in it. It can be a PITA, Pain In The Arse, especially if you have many records that are bad. We have not found a way to prevent it at this point. Steve Jones Pete Olshavsky <polshavsky@xxxxxxxxx> Sent by: mapics-l-bounces@xxxxxxxxxxxx 12/13/2005 10:05 AM Please respond to MAPICS ERP System Discussion <mapics-l@xxxxxxxxxxxx> To mapics-l@xxxxxxxxxxxx cc Subject [MAPICS-L] excel to as400 Morning everyone. I am trying to take an excel spreadsheet that I initially created from the 400 with data. Some data was keyed inot columns that I provided. When I try to transfer the spreadsheets back to the 400 I am getting errors that data in this field is incorrect or does not match the PC data type. I think what has happened is the users keyed into a flds that they were not meant to. I have tried using the data transfer off the client access session. I have also tried using the data transfer option on the speadsheet itself. Neither works. Hope this makes sense..... Is there a way to prevent this??? Thanks in advance... Pete Olshavsky _______________________________________________ This is the MAPICS ERP System Discussion (MAPICS-L) mailing list To post a message email: MAPICS-L@xxxxxxxxxxxx To subscribe, unsubscribe, or change list options, visit: http://lists.midrange.com/mailman/listinfo/mapics-l or email: MAPICS-L-request@xxxxxxxxxxxx Before posting, please take a moment to review the archives at http://archive.midrange.com/mapics-l.
As an Amazon Associate we earn from qualifying purchases.
Operating expenses for this site are earned using the Amazon Associate program and Google Adsense.