Re: FoxPro Data Load

[Clark Kristie <Clark_Kristie@PRC.COM>]

Just wanted to add that I agree with creating the text file and using
that as input to Oracle.  I have examples of these type of programs
where you read in a flat file and insert into oracle, if you are
interested.

Kristie Clark
Litton/Enterprise Solutions


> ----------
> From:         Satish KARRY[SMTP:Satish_Karry@EL.NEC.COM]
> Sent:         Tuesday, March 31, 1998 2:02 PM
> To:   Multiple recipients of list SQR-USERS
> Subject:      Re: FoxPro Data Load
>
>      Hi
>
>      The solution given below may not be the best. But I think it
> works.
>      The foxpro DBF can be saved as a text file with fixed length or
> comma
>      separated. Once the file is stored that way, it is easier to
> write the
>      sqr for a text file to Oracle.
>
>      Step1 :      Copy the dbf to another files as comma separated or
>                   fixed lenght format.
>
>      Step2 :     Write a sqr which reads the text file and inserts
> into
>                 oracle. Or use sql loader.
>
>
>
>     Satish KARRY
>
> ______________________________ Reply Separator
> _________________________________
> Subject: FoxPro Data Load
> Author:  Paige McFall <mcfall@CMCMFG.COM> at INTERNET
> Date:    3/31/98 11:16 AM
>
>
> I would like to take data that is loaded in a FoxPro .dbf file
> (Microsoft FoxPro Database) and load it in our Oracle Tables.  Is
> anyone
> doing anything similar in SQR that would accomplish this?    We can
> create an ODBC driver and link to the FoxPro Tables via a DSN.  I have
> talked to SQR and they told us that people were successfully using
> Access although it is not "supported" by SQR in the Workbench Product.
> We have been able to connect to the database and view the tables and
> columns in Workbench.  However, I am wondering how we can write the
> code
> to accomplish the load from FoxPro to Oracle.   We may be chasing our
> tails here but I thought someone out there may be doing something
> similar or had maybe tried this.
>