Re: FoxPro Data Load

[Murray Leckie <MLeckie@SIERRASYS.COM>]

How big are the files and what is the complexity of the foxpro database?
I have opened dbf files in excel and saved as prn format and loaded
oracle tables through SQR for PeopleSoft.  If you need an example, let
me know.

Murray

> -----Original Message-----
> From: Paige McFall [SMTP:mcfall@CMCMFG.COM]
> Sent: Tuesday, March 31, 1998 1:16 PM
> To:   Multiple recipients of list SQR-USERS
> Subject:      FoxPro Data Load
>
> 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.