Re: Converting to ASCII from the AS/400

You can simply FTP them with a ASCII option. The result will be an ascii 
text file, fixed width.

You can do a bit more with Excel/Access using ODBC (SLOW-DBC) or Client 
Access.

We had a similar challenge getting DBIII tables into Browser, we wound up 
simply
printing the data to a fixed width text file and uploading to AS/400 using 
Client Access.

I would recommend knowing where you're going first and exporting 
accordingly.
You will save yourself a lot of time & hair!






Nick_Radich@xxxxxxxxxxxxxx 
Sent by: mapics-l-bounces@xxxxxxxxxxxx
04/26/2006 12:32 PM
Please respond to
MAPICS ERP System Discussion <mapics-l@xxxxxxxxxxxx>


To
MAPICS ERP System Discussion <mapics-l@xxxxxxxxxxxx>
cc

Subject
[MAPICS-L] Converting to ASCII from the AS/400






Hello everyone,

Does anyone know of a tool or utility that will allow me to convert AS/400 

files to ASCII?  I want to FTP these files to another System, unknown type 

at this time, and they need it in ASCII format.

Thanx,

Nick


Nick Radich
Sr. Programmer/Analyst
EPC Molding, Inc.
Direct  (320) 679-6683
Toll free  (800) 388-2155  ext. 6683
Fax  (320) 679-4516
nick_radich@xxxxxxxxxxxxxx
_______________________________________________
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.