Re: excel to as400

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.