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

I echo Rob's suggestions. I explored the second item that refers to work
from Scott Klement. I built spreadsheets with the field names as part of
the column headings and always in row 4. The parsing routines could be
modified to use that information for mapping to the data fields.

We were looking for a solution for budgeting purposes. Scott did another
great job with this programs.

Nick W. Mart

Here's one method:
http://faq.midrange.com/data/cache/194.html

Here's another:
http://faq.midrange.com/data/cache/533.html

Rob Berendt
--
Group Dekko Services, LLC
Dept 01.073
PO Box 2000
Dock 108
6928N 400E
Kendallville, IN 46755
http://www.dekko.com





sunny singh <franky_four_fingures@xxxxxxxxx>
Sent by: midrange-l-bounces@xxxxxxxxxxxx
09/05/2006 11:02 AM
Please respond to
Midrange Systems Technical Discussion <midrange-l@xxxxxxxxxxxx>


To
MIDRANGE-L@xxxxxxxxxxxx
cc

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






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



---------------------------------
Get your email and more, right on the  new Yahoo.com
--
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.