×

Good News Everybody!

A new search engine is coming soon.

As a stop gap measure, we are using Google's custom search engine service.




Are you using the plugin from within excel? I've never used it, but one
of the developers we used to have did, and he had a link to this page in
our internal documentation.
https://www-304.ibm.com/support/docview.wss?uid=nas8N1019202



Kevin Bucknum
Senior Programmer Analyst
MEDDATA/MEDTRON
Tel: 985-893-2550

-----Original Message-----
From: MIDRANGE-L [mailto:midrange-l-bounces@xxxxxxxxxxxx] On Behalf Of
Hoteltravelfundotcom
Sent: Monday, April 18, 2016 12:16 PM
To: Midrange Systems Technical Discussion
Subject: Re: Speaking of data transfers


question is, where and how to create this FDF.

On Fri, Apr 15, 2016 at 10:12 AM, Rob Berendt <rob@xxxxxxxxx> wrote:

I know that having more than one point on an email now a days can lose

a lot of people's attention span but did you notice the thing at the
bottom?
<snip>
But the basic thing to remember is that the DB2 file has to exist.
The transfer will not create one.
</snip>


Rob Berendt
--
IBM Certified System Administrator - IBM i 6.1 Group Dekko Dept 1600
Mail to: 2505 Dekko Drive
Garrett, IN 46738
Ship to: Dock 108
6928N 400E
Kendallville, IN 46755
http://www.dekko.com





From: Hoteltravelfundotcom <hoteltravelfun@xxxxxxxxx>
To: Midrange Systems Technical Discussion
<midrange-l@xxxxxxxxxxxx>
Date: 04/15/2016 09:44 AM
Subject: Re: Speaking of data transfers
Sent by: "MIDRANGE-L" <midrange-l-bounces@xxxxxxxxxxxx>



simple upload using data transfer to IBMi.
Option 2 on your list.

On Fri, Apr 15, 2016 at 9:27 AM, Rob Berendt <rob@xxxxxxxxx> wrote:

There's a few things to consider here:
- Simply transferring an Excel spreadsheet from your PC to somewhere

in the IFS on your IBM i or
- Trying to take data from an Excel spreadsheet and transfer it into

a
DB2
file in the /QSYS.LIB file system.

If you are trying to do the latter then there's other things to
consider.
1 - Are you willing to use the Excel plug-in to transfer data from
Excel directly into a DB2 file, or
2 - Are you trying to use the Data Transfer from IBM i Access Client

Solutions?
3 - Are you trying to use the deprecated IBM i Client Access for
Windows Data Transfer?

If you're using 3 I won't help you.

But the basic thing to remember is that the DB2 file has to exist.
The transfer will not create one.




Rob Berendt
--
IBM Certified System Administrator - IBM i 6.1 Group Dekko Dept 1600

Mail to: 2505 Dekko Drive
Garrett, IN 46738
Ship to: Dock 108
6928N 400E
Kendallville, IN 46755
http://www.dekko.com





From: Hoteltravelfundotcom <hoteltravelfun@xxxxxxxxx>
To: Midrange Systems Technical Discussion
<midrange-l@xxxxxxxxxxxx>
Date: 04/15/2016 09:13 AM
Subject: Speaking of data transfers
Sent by: "MIDRANGE-L" <midrange-l-bounces@xxxxxxxxxxxx>



HI I have not done this in a long time. the simple data transfer on
the Data transfer to i.

I selected the pc file which is an excel.

then i selected the file and member and lib but i get a error
message 'The system cannot find the file specified'

why is that?
--
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.

Please contact support@xxxxxxxxxxxx for any subscription related
questions.


--
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.

Please contact support@xxxxxxxxxxxx for any subscription related
questions.

--
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.

Please contact support@xxxxxxxxxxxx for any subscription related
questions.


--
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.

Please contact support@xxxxxxxxxxxx for any subscription related
questions.

--
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.

Please contact support@xxxxxxxxxxxx for any subscription related
questions.

As an Amazon Associate we earn from qualifying purchases.

This thread ...

Follow-Ups:
Replies:

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

This mailing list archive is Copyright 1997-2026 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.