× The internal search function is temporarily non-functional. The current search engine is no longer viable and we are researching alternatives.
As a stop gap measure, we are using Google's custom search engine service.
If you know of an easy to use, open source, search engine ... please contact support@midrange.com.



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.





As an Amazon Associate we earn from qualifying purchases.

This thread ...

Replies:

Follow On AppleNews
Return to Archive home page | Return to MIDRANGE.COM home page

This mailing list archive is Copyright 1997-2024 by midrange.com and David Gibbs as a compilation work. Use of the archive is restricted to research of a business or technical nature. Any other uses are prohibited. Full details are available on our policy page. If you have questions about this, please contact [javascript protected email address].

Operating expenses for this site are earned using the Amazon Associate program and Google Adsense.