|
midrange.com
I had a one-shot project a couple of months ago where I needed to upload a
large spreadsheet for merging into a database file. My issues centered
around fields with single and double-quotes in them. Uploading via Client
Access, FTP had problems getting spreadsheet cells into the correct fields.
Ultimately, I imported from Excel into an Access database and then used
ODBC to transfer it into an AS/400 database file. I also defined
everything as text and then wrote a simple program to move and reformat the
uploaded data into another database file with fields of the proper type.
There are probably better ways to do it but like I said, it was a one-shot
project that didn't involve user interaction and it got the job done.
Dave Parnin
Nishikawa Standard Company
Topeka, IN 46571
daparnin@xxxxxxxxxxxxxx
rob@xxxxxxxxx
Sent by: To: Midrange Systems
Technical Discussion
midrange-l-bounces@m <midrange-l@xxxxxxxxxxxx>
idrange.com cc:
Subject: Re: From Excel to
AS400 Database file - Using Client
Access
04/27/2005 10:25 AM
Please respond to
Midrange Systems
Technical Discussion
First of all, remove any columns.
Failing that, we had a similar problem. It was danged hard to track down
using the direct transfer. I think we ended up converting to a comma
separated file, sending that up, and then using CPYFRMIMPF. Then we could
find the offending row. It got really close to the point where we were
going to trash CPYFRMIMPF and use a rpgle program and the IFS api's to
process the data directly to give us more granularity of control.
Rob Berendt
--
Group Dekko Services, LLC
Dept 01.073
PO Box 2000
Dock 108
6928N 400E
Kendallville, IN 46755
http://www.dekko.com
<ganeshkumar.murugesan@xxxxxxxxx>
Sent by: midrange-l-bounces@xxxxxxxxxxxx
04/27/2005 10:15 AM
Please respond to
Midrange Systems Technical Discussion <midrange-l@xxxxxxxxxxxx>
To
<midrange-l@xxxxxxxxxxxx>
cc
Subject
>From Excel to AS400 Database file - Using Client Access
I have an excel sheet with data and I need to put that data into an
AS400 database file. The database file on AS400 already exists with a
defined format and the excel also has data in that format. How do I
transfer it? I'm getting field length mismatch error when I try to use
the "Send file to Host"
Thanks,
Ganesh
Confidentiality Notice
The information contained in this electronic message and any attachments
to this message are intended
for the exclusive use of the addressee(s) and may contain confidential or
privileged information. If
you are not the intended recipient, please notify the sender at Wipro or
Mailadmin@xxxxxxxxx immediately
and destroy all copies of this message and any attachments.
--
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.
As an Amazon Associate we earn from qualifying purchases.
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.
