Re: prob: to convert data from an excel sheet onto the as400 environment.

Don -

<vendor response>
Our RPG2SQL product includes native Excel functionality. This means that it 
does not use SQL methods, rather, it uses the OLE automation of Excel. One of 
the new utilities is a command called SQLXLSIMP that reads data from a 
spreadsheet directly into a PF - some assumptions are made. There are plans for 
an SQLXLSEXP for exporting to Excel, although we have another export product 
that can do that pretty well.

The import command uses the functions of the RPG2SQL product to do its work and 
understands the data types of the PF and Excel.

This is all done from the iSeries, not from the PC.

Demo and evaluation copies are available - check out 
www.rjssoftware.com
or call 888.RJS.SOFT (toll-free) or 952.989.3038
</vendor response>

Vern

-------------- Original message -------------- 
From: Don <dr2@xxxxxxxx> 

OK, time for me to weigh in on this. 

I'm not sure why the tools guys haven't come up with a utility to do this 
function yet. We've got several vendors out there with most of the GUI 
already done and that do database to database conversion, downloads from 
database(s) to .xls, yet the UPLOAD part is grossly missing. 

I've personally buttonholed a few vendors (Linoma, Prodata, etc) to add 
this to their offerings list in the last year, so please, those of you that 
are going to Las Vegas or Miami, please push for something like this. 

Preliminarily, I would see a product that does: 

Upload with add/replace records into a PF/LF. 
Select which fields to add/change simularly to how DBU does it's field 
selection 
Security - several ways to do this 
FIELD MAPPING from column to field name in the database - be it DB2, 
Oracle, etc... 
Key field selection/sequencing 
Audit log 


The download part has been there for a long time...how about an UPLOAD 
option? 

Frankly, I think the first one that makes it to market will have a helluva 
lot of sales...but that's JMHO... 

Don in DC 


At 08:02 AM 9/5/2006 -0700, you wrote: 

good morning everybody 

i have a prob.suppose i have my data on an excel sheet and i want to 
use that data data in my rpg program. how can i copy that data into the 
pf.or what should be the best method to do so. 
please help me out o find the right answer. 
thank you 

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