RE: excel to as400

That sounds like way to much work.  Enter the data in columns.  Then is you
have numbers that have to be read as alpha change that in excel using the
TEXT(XX99,0) command and copy the result over the original column as values.
That way you can convert an entire column from numbers to text.  Text typed
in will always come out as text so that shouldn't be the issue.  Then you
can either save as a CSV or upload using data transfer from within Excel.

The important thing is match your data to the type the FDF thinks it is.

-----Original Message-----
From: mapics-l-bounces@xxxxxxxxxxxx [mailto:mapics-l-bounces@xxxxxxxxxxxx]
On Behalf Of Pete Olshavsky
Sent: Tuesday, December 13, 2005 10:08 AM
To: MAPICS ERP System Discussion
Subject: RE: [MAPICS-L] excel to as400

Yes. What it appears to be is either numeric in alpha or alpha in numeric.. 
   
  Would it make it easier to make everything alpha. then once I get it to
the 400. have a program to convert flds I want to be numeric? 

Ann Neal <aneal@xxxxxxxxxxxxxxxxxx> wrote:
  Pete,

Does the error message tell you the row number with the incorrect data?

Ann

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


_______________________________________________
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.

  

_______________________________________________
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.


This correspondence may contain confidential information intended for the
use of the individual or entity to which it is addressed. If the reader of
this electronic message is not the intended recipient, or the employee or
agent responsible to deliver it to the intended recipient, you are hereby
notified that any dissemination, distribution or copying is strictly
prohibited. If you have received this e-mail in error, please notify the
sender immediately by e-mail and immediately destroy this e-mail and its
attachments.