Pete, You probably won't like how we handle this at Fleetwood. We don't allow people to do this. If they have a data entry application, they do it on the iSeries. Period. It's such a terrific database handler, and has good enough reporting tools that we can't come up with a rational reason for why anyone would do it the other way. Of course, you do realize that this is this way at Fleetwood due to our users - and you are familiar with them. Most of them think a spreadsheet is something you put on a bed..... And the good ones prefer to pull the data from MAPICS (or other apps) and put it into spreadsheets if they want - they don't go the other way. They like their green screens and Browser. Dale Gindlesperger IT Manager/Special Projects Leader Fleetwood Folding Trailers, Inc. 258 Beacon Street Somerset, PA 15501 Pete Olshavsky <polshavsky@yahoo .com> To Sent by: mapics-l@xxxxxxxxxxxx mapics-l-bounces@ cc midrange.com Subject [MAPICS-L] excel to as400 12/13/2005 10:05 AM Please respond to MAPICS ERP System Discussion <mapics-l@midrang e.com> 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.