|
I use the macros to send and receive directly from/to EXCEL in the toolbar named iseries access.
-----Message d'origine-----
De : midrange-l-bounces@xxxxxxxxxxxx [mailto:midrange-l-bounces@xxxxxxxxxxxx] De la part de Alan Shore
Envoyé : jeudi 15 janvier 2009 21:57
À : Midrange Systems Technical Discussion
Objet : Re: Create dds from fdf
Hi Gary
save the file from Excel as a CSV file
if you have Client access, here an overview of what can be tried, click on Actions, then Send File to Host another window should appear (Data Transfer To iSeries) click Tools click Create iSeries Database file - this will display a Wizard. Follow these instructions and an fdf file will be created.
Eventually, the wizard will finish
The Data Transfer To iSeries window should then have both the PC file name AND the iseries file name filled in Press Transfer data to iseries and the data will be loaded to your system.
Alan Shore
Programmer/Analyst, Distribution
E:AShore@xxxxxxxxxxx
P:(631) 200-5019
C:(631) 880-8640
"If you're going through Hell, keep going" - Winston Churchill
midrange-l-bounces@xxxxxxxxxxxx wrote on 01/15/2009 03:37:53 PM:
I have a csv file with a lot of fields in it that I would like to gotonto an
i5. I can bring up the file in Excel and create an FDF with the fieldnames.
DDS.
Does anyone know of a program on the i5 that will convert an FDF file
to
I don't have the file created on the i5. Client Access won'tfile
createthe
on the i5 from Excellist
Thank you,
Gary Kuznitz
--
This is the Midrange Systems Technical Discussion (MIDRANGE-L) mailing
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.
--
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.