RE: excel to as400

Hi Pete,

I export the data to CSV or tab delimitated files for transferring to and from 
the 400, this gets around the problem of Excel reformatting fields which appear 
numeric but should really be text (our component parts are, for example 
"755.50", so this happens frequently). If the problem is the users incorrectly 
entering the data, Excel has functions for data validation and worksheet 
protection that may help you, search for them in the help files.

Regards,
Regards,
Alan Bell
IT Leader
Munster Simms Engineering Ltd.
P: +44 (0)28 9127 6519
F: +44 (0)28 9146 6421
M: +44 (0)7710 815276
E: alanb@xxxxxxxxxxxxxx <mailto:alanb@xxxxxxxxxxxxxx>

-----Original Message-----
From: mapics-l-bounces@xxxxxxxxxxxx
[mailto:mapics-l-bounces@xxxxxxxxxxxx]On Behalf Of Pete Olshavsky
Sent: 13 December 2005 15:05
To: mapics-l@xxxxxxxxxxxx
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.