Re: uploading dbase files using iSeries Access for windows

I know you have resolved this by getting a diff format, but since mid 90's I've run some free utilities by Bruce Guthrie
http://users.erols.com/waynesof/bruce.htm
(some of this originally written for US Commerce Dept).
Among many other file formats, dBase to ascii-delimited or fixed length text.
Never a hiccup. Allows you to build a simple dos batch file for automated processing.
Also - I avoid Client Access uploads whenever possible - use ftp and either
cpyfrmstmf or cpyfrmimpf or Scott Klements RPGLE to read/write ifs files.
jim franz

----- Original Message ----- From: "John Arnold (MFS)" <jarnold@xxxxxxxxxxxxxxxxxxxxxxxxxx>
To: "Midrange Systems Technical Discussion" <midrange-l@xxxxxxxxxxxx>
Sent: Thursday, November 03, 2011 3:44 PM
Subject: RE: uploading dbase files using iSeries Access for windows

Thanks everyone for your responses.
I guess I was not clear. I want to load data I am receiving from an
external entity as a dbase table onto the i.
Simple answer - I went back to the entity and requested a csv.

Thanks,
John

-----Original Message-----
From: midrange-l-bounces@xxxxxxxxxxxx
[mailto:midrange-l-bounces@xxxxxxxxxxxx] On Behalf Of Pat Barber
Sent: Thursday, November 03, 2011 2:12 PM
To: Midrange Systems Technical Discussion
Subject: Re: uploading dbase files using iSeries Access for windows

What do you want the file to look like on the I ?

What do mean by "converting" ?




On 11/3/2011 11:54 AM, John Arnold (MFS) wrote:

Is it possible to upload dbase files directly to the i without
converting the data to another format?

The option does not exist in the iSeries Access choices.

Is there an easy way to do this?

I am receiving a set of data from a client in .dbf format each month
and would like to minimize the conversions if possible.

--
This is the Midrange Systems Technical Discussion (MIDRANGE-L) mailing
list To post a message email: MIDRANGE-L@xxxxxxxxxxxx To subscribe,
unsubscribe, or change list options,
visit: http://lists.midrange.com/mailman/listinfo/midrange-l
or email: MIDRANGE-L-request@xxxxxxxxxxxx Before posting, please take a
moment to review the archives at http://archive.midrange.com/midrange-l.

--
This is the Midrange Systems Technical Discussion (MIDRANGE-L) mailing list
To post a message email: MIDRANGE-L@xxxxxxxxxxxx
To subscribe, unsubscribe, or change list options,
visit: http://lists.midrange.com/mailman/listinfo/midrange-l
or email: MIDRANGE-L-request@xxxxxxxxxxxx
Before posting, please take a moment to review the archives
at http://archive.midrange.com/midrange-l.