In article <[log in to unmask]>, Mark Undrill
<[log in to unmask]> writes
>In article <[log in to unmask]>, Jim Phillips
><[log in to unmask]> writes
>>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.
>>
><SNIP> Signature
>
>OR
>
>4) This is the same as #2 & #3, use FCOPY to create the sequential
>(flat) file as follows:
>
>        :FCOPY FROM=ksamdatafile;TO=flatfile;NEW
>
>HTH
Later in the day (after my first cup of coffee). The FCOPY option will
not convert non ASCII data such as binary or packed decimal numbers if
you have them. I don't know if ACCESS is able to do this.
--
Mark Undrill                            Telephone: +44 (0)1684 291710
Affirm Limited                          Fax.:      +44 (0)1684 291712
The Great Barn, Mill Street             e-mail:    [log in to unmask]
TEWKESBURY
GL20  5SB       U.K.