RE: uploading dbase files using iSeries Access for windows

[Richard Schoen <richard@xxxxxxxxxxxxxxx>]

Could write a VB or VB.Net app to do the data uploads and write to the databases directly using the CA/400 database drivers. 

Read Dbase -> Write DB2.

Regards,
Richard Schoen
RJS Software Systems Inc.
Where Information Meets Innovation
Document Management, Workflow, Report Delivery, Forms and Business Intelligence
Email: richard@xxxxxxxxxxxxxxx
Web Site: http://www.rjssoftware.com
Tel: (952) 736-5800
Fax: (952) 736-5801
Toll Free: (888) RJSSOFT

------------------------------

message: 7
date: Thu, 3 Nov 2011 17:42:03 +0000
from: "Harman, Roger" <Roger.Harman@xxxxxxxxxx>
subject: RE: uploading dbase files using iSeries Access for windows

I deal with dBase files all the time.  We just convert them to what dBase called SDF.  Flat, fixed length ASCII.  

We use a generic utility program I wrote eons ago that does a dBase "use [somefile]" and "copy to [somefile].txt type sdf" and "quit".  Easy to put in a PC job stream.