RE: Getting data into a PF from an Excel spreadsheet

CPYFRMIMPF +
FROMSTMF('/ascend/muoc/weekly/bio/BioDemo.c+
sv') TOFILE(MUOLIB/MUHPBIO) MBROPT(*ADD) +
RCDDLM(*CRLF) FROMRCD(2) RPLNULLVAL(*FLDDFT)

Copying from record 2 avoids uploading the column headings. This file happens to reside in our IFS. However, it could be on any server in your network.


Thanks!
Mary

¤»¥«¤»§«¤»¥«¤»§«¤»¥«¤»§«¤»¥«¤»§«¤»¥«¤»§«¤»¥«¤»§«¤»¥«¤»§«¤»¥«
Mary Kern
Director of Information Services
University of Toledo Foundation
2801 W Bancroft St Mail Stop 319, Toledo, OH 43606
Voice: (419) 530-5611 (800) 640-0147 Fax: 419-530-2895
Email: Mary.kern4@xxxxxxxxxxx
"Three things in human life are important. The first is to be kind.
The second is to be kind. The third is to be kind. -- Henry James
¤»¥«¤»§«¤»¥«¤»§«¤»¥«¤»§«¤»¥«¤»§«¤»¥«¤»§«¤»¥«¤»§«¤»¥«¤»§«¤»¥«


-----Original Message-----
From: midrange-l-bounces+mkern4=utnet.utoledo.edu@xxxxxxxxxxxx [mailto:midrange-l-bounces+mkern4=utnet.utoledo.edu@xxxxxxxxxxxx] On Behalf Of James Lampert
Sent: Thursday, August 23, 2007 6:38 PM
To: 'Midrange Systems Technical Discussion'
Subject: Getting data into a PF from an Excel spreadsheet

Fellow Geeks:

Can anybody recommend a fairly simple way to get data from an Excel
spreadsheet into a physical file (given that we first create a physical
file with appropriate fields to receive the data)?

While the end-user is probably on V5, and might be a Host Servers shop,
let's for the moment assume that it has to work on a V4R4 box that is
*not* running Host Servers.