RE: What is the best way to import data from a spreadsheet to iSeries file?

["John Wallroff" <JWALLROFF@xxxxxxxxxxxxxxxxxxxxxxx>]

You can do it with iSeries access but it's kind of a pain to upload
data.  You have to create a file ahead of time with the correct field
types and lengths.  Then put a record in it and download to your PC to
generate the .FDF file needed to define the iSeries file.  Then you can
upload your real file to the iSeries using the .FDF.

You can also use the IBM plug in for Excel to upload data from an .xls
file.

What I've used recently and the easiest is Surveyor/400 from Linoma
Software.

http://www.linomasoftware.com/home.html

John.



-----Original Message-----
From: midrange-l-bounces@xxxxxxxxxxxx
[mailto:midrange-l-bounces@xxxxxxxxxxxx] On Behalf Of Booth Martin
Sent: Tuesday, December 06, 2005 2:30 PM
To: midrange-l@xxxxxxxxxxxx
Subject: What is the best way to import data from a spreadheet to
iSeries file? 

What is the best way to import data from a spreadsheet to iSeries file, 
not using Java, which I do not know?

I thought this had just been discussed, but I can not find it.