Re: FoxPro Data Load

[Satish KARRY <Satish_Karry@EL.NEC.COM>]

     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.