RE: Converting DBF File

["Giri Gopal" <GiriGopal@xxxxxxxxxx>]

USE ASP/vb/wsh script to read your data (excel/csv/text) and insert records
into the AS/400 Database without the hassle of converting from excel to csv
etc and ftp to as/400. It works great. You can run it via web or from dos
prompt's. If you get the files as a download from different customers at  a
specific time, setup a scheduler on the pc to run your script at a certain
time and in your script check for the file and then do what ever needs to be
done to upload.

Good Luck

GG


-----Original Message-----
From: rpg400-l-admin@midrange.com [mailto:rpg400-l-admin@midrange.com]On
Behalf Of Smith, Mike
Sent: Wednesday, January 16, 2002 2:46 PM
To: 'rpg400-l@midrange.com'
Subject: RE: Converting DBF File


http://users.erols.com/waynesof/bruce.htm

-----Original Message-----
From: Ray, Adam [mailto:ARay@WIPFLI.com]
Sent: Wednesday, January 16, 2002 3:41 PM
To: 'rpg400-l@midrange.com'
Subject: RE: Converting DBF File


I transfer quite a few files (database, excel, text) to our AS/400 as well.
Where can I get my hands on this utility?

Thanks,

Adam Ray
Programmer/Analyst
715.833.0764 x110
aray@wipfli.com <mailto:aray@wipfli.com>

Wipfli Ullrich Bertelson LLP
www.wipfli.com <http://www.wipfli.com>

        <snip>

        the only way i have been able to figure out to do it, is to use a
little
        freeware utility called Convert.exe by Bruce Guthrie and convert the
DBF
        file to an ASCII text file and then transfer the data to the 400.

        </snip>




__________________________________________________________________

Please look below this disclaimer for attachments.

This email and any files transmitted with it are confidential and
intended solely for the use of the individual or entity to whom they
are addressed. This communication may contain material protected by
attorney-client privilege. If you are not the intended recipient or
the person responsible for delivering the email to the intended
recipient, be advised that you have received this email in error and
that any use, dissemination, forwarding, printing, or copying of this
email is strictly prohibited. If you have received this email in error
please notify the Information Systems Manager by telephone at (715)845-3111

postmaster@wipfli.com
http://www.wipfli.com

____________________________________________________________________

This message has been generated by MIMEsweeper. This message and
attachments have been swept for all known and recorded computer viruses.
_______________________________________________
This is the RPG programming on the AS400 / iSeries (RPG400-L) mailing list
To post a message email: RPG400-L@midrange.com
To subscribe, unsubscribe, or change list options,
visit: http://lists.midrange.com/cgi-bin/listinfo/rpg400-l
or email: RPG400-L-request@midrange.com
Before posting, please take a moment to review the archives
at http://archive.midrange.com/rpg400-l.
_______________________________________________
This is the RPG programming on the AS400 / iSeries (RPG400-L) mailing list
To post a message email: RPG400-L@midrange.com
To subscribe, unsubscribe, or change list options,
visit: http://lists.midrange.com/cgi-bin/listinfo/rpg400-l
or email: RPG400-L-request@midrange.com
Before posting, please take a moment to review the archives
at http://archive.midrange.com/rpg400-l.