RE: Create dds from fdf

[Alan Shore <AlanShore@xxxxxxxx>]

Hi Gary
can you please elaborate?
What are the steps you are taking?


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/16/2009 12:04:09 PM:

> I am using the macros.  When I do I get the SQL error.  How can I fix the

> error?
>
> Thanks,
>
> Gary Kuznitz
>
> On 16 Jan 2009 at 9:54, David (David FOXWELL <midrange-l@midrange.
> com>) commented about RE: Create dds from fdf:
>
> > 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 got
> > onto an
> > > i5.  I can bring up the file in Excel and create an FDF with the
field
> > names.
> > > Does anyone know of a program on the i5 that will convert an FDF file
> > > to
> > DDS.
> > > I don't have the file created on the i5.  Client Access won't
> > > createthe
> > file
> > > on the i5 from Excel
> > >
> > > Thank you,
> > >
> > > Gary Kuznitz
> > >
> > >
> > > --
> > > 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
> .
> > --
> > 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.