HP3000-L Archives

August 1997, Week 3

HP3000-L@RAVEN.UTC.EDU

Options: Use Monospaced Font
Show Text Part by Default
Show All Mail Headers

Message: [<< First] [< Prev] [Next >] [Last >>]
Topic: [<< First] [< Prev] [Next >] [Last >>]
Author: [<< First] [< Prev] [Next >] [Last >>]

Print Reply
Subject:
From:
Jim Phillips <[log in to unmask]>
Reply To:
Jim Phillips <[log in to unmask]>
Date:
Tue, 19 Aug 1997 10:27:25 -0400
Content-Type:
text/plain
Parts/Attachments:
text/plain (37 lines)
On Tue, 19 Aug 1997 14:24:58 PDT, Zuheir Sayyed Ahmed <[log in to unmask]>
(actually Salem Maharik) writes:

>Dear Sirs;
>
>I am working as a computer technician in Polytechnic Institute in the city
>of Hebron , Palestine. I have KSAM files stored on HP3000-42 main frame
>computer working with MPE V operating system, How can I transfer these
data
>files to my PC in order to be used with  my application program designed
in
>Microsoft Access 2.0 under windows 3.11, would you please tell me what
>hardware and software I will need to transfer these data files, or the
>Email address of the HP3000  specialists' persons who can help me. I will
>not forget your help , waiting your reply.

Well, there are many ways to accomplish your task:

1) Use one of the third-party ODBC products which, I believe, will allow 
direct access to the KSAM data from a PC.

2) Write a program on the HP in your favorite computer language to create 
a sequential (flat) file of the KSAM data which you then download to the 
PC and import into MS Access.  I do this all the time.  MS Access can 
import fixed length ASCII records into existing tables with no trouble.

3) This is the same as #2, except you can use Suprtool (from Robelle 
Consulting) to extract the KSAM data into a flat file for import into 
MS Access.

Hope this helps.

Jim Phillips                            Manager of Information Systems
E-Mail: [log in to unmask]      Therm-O-Link, Inc.
Phone: (330) 527-2124                   P. O. Box 285
  Fax: (330) 527-2123                   Garrettsville, Ohio  44231

ATOM RSS1 RSS2