How to access FoxPro?

[laurax]

HI all,
I never used FoxPro before. I need to read data from FoxPro 2.6 tables and save them to Oracle database.
Will a java program work? or I must write Windows application?
what kind of driver I need to access the FoxPro? ODBC driver? where can I find the driver?

too many questions..

Thanks a lot.

 

[DSummZZZ]

I don't know what sort of import capabilities oracle has, but you can export fox tables in many different formats, such as comma delimited, Excel, and so on.
Look up the COPY TO command.


-Dave Summers-

Even more Fox stuff at:

http://www.davesummers.net/foxprolinks.htm

 

[TheRambler]

As far as I know Oracle has SQL*Loader, an utility to import text files into Oracle tables, which could be used to read the file produced by the COPY TO command. I would do the following:

USE yourTable
COPY TO yourTable.txt DELIMITED WITH TAB

and then import yourTable.txt with SQL*Loader. If you don't have FoxPro, you could open the table with Excel and save it as a text file delimited with tabs.

 

[laurax]

Hi Thanks for your answer,

I don't want to dump all the data from FoxPro to Oracle. So I have to read some data from FoxPro table and process it and save it to Oracle DB.

I tried sun jdbc-odbc driver. It seems working fine. But with this free solution, the FoxPro DBF files have to be shared on the network (in the same windows domain I suppose)
Because there is no dedicated database server for FoxPro. I have use Window's file sharing machanism for remote access.

Does anybody know better method?

 

[DSummZZZ]

You pretty much have one of the few solutions available - ODBC.
Foxpro tables aren't like Oracle or SQL databases as you know them, they are basically flat text files containing a 'header' record consisting of the structure of the table, the fields' and records' sizes, and pointers to the beginning of data.
So yes, you have to use Window's file sharing mechanism to use them, no matter which ODBC driver you use.


-Dave Summers-

Even more Fox stuff at:

http://www.davesummers.net/foxprolinks.htm

 

[TheRambler]

Have you seen JavaDBF?
I've never used it, but you may want to give it a try.

 

[laurax]

Thanks Dave,

Can I connect to Oracle database from FoxPro 2.6? ( I know Visual FoxPro have functions like SQLStringConnect(), but I am not sure about FoxPro 2.6)
Where can I find some tutorail for FoxPro 2.6?

Thanks

 

[DSummZZZ]

I don't know of a way to use Foxpro 2.x to connect to Oracle.
It is relatively easy to do with VFP though.
And there are several tutorials on doing that.


-Dave Summers-

Even more Fox stuff at:

http://www.davesummers.net/foxprolinks.htm

 

[TamarGranor]

To use FoxPro 2.x to connect to other back-ends, you need the FoxPro Connectivity Kit. If you don't already have it, I'm not sure where you'd get it today (given that FoxPro 2.6 shipped in 1992).

Tamar

 

[mmerlinn]

Various versions of FoxPro pop up on eBay. I have bought several copies of VFP 3.0 & FP 2.6 for under $20 for complete unopened legit copies, mostly to get new manuals to replace my dog-ear ones. Have ebay email you when something is listed.l