FoxPro to MySQL

[dereckreynolds]

Hi

I'm new to FoxPro.

I have a FoxPro application (16-bit, sorry, dont know which release of FoxPro this is) that I have inherited in a new job. It is used to manage a property portfolio for a real estate company.

We need to integrate the property data into a new website which is using a MySQL databse on Linux OS. I learned that ODBC connectors can be used to access FoxPro and import the data into MySQL. Is this true? If so can you help me out with some tips please?

AJ.

 

[ericbrunson]

You can use an ODBC driver to connect to foxpro and extract the data, then you can import the data into your new database. However, these ODBC drivers aren't magic, you will have to write some sort of extraction utility and use some sort of import utility to get the data into MySQL.

You may be better of finding a utility that can simply dump your data from FP into character delimited files. No need to use ODBC, that's just complicating the issue.

 

[BitFuzzy]

<--
You may be better of finding a utility that can simply dump your data from FP into character delimited files. No need to use ODBC, that's just complicating the issue.
-->

While I agree in full with the above, I'd have to think you're going to have a problem locating something ready to run out of the box, unless the software had a following at which point you may be able to find something.

"IF" you know what the database names are for the Foxpro app, you may be able to import the data into Office or Ooo then save as a delimited file for insertation into MySQL.

Other than that, you may need to locate a foxpro developer willing to take a look at databases and create a custom export utility.

"IF" there's no major issues it shouldn't take more that an hour or so.

 

[ingresman]

I believe Foxpro uses dbf format, on windows2000 you get a foxpro driver. so at least you should be able to get at the data. I'd iniialy get a script together which would extract the data into csv and load it into mysql.
You can write all the code using .vbs under windows or if your brave use php

 

[ingresman]

just had another little think. If you have excel you can load the data from odbc sources (data->get external data) and manipulate it to your hearts content.

 

[JustKIDn]

Foxpro is pretty simple. It's just a plain .DBF file.
Foxpro has it's own command line so if you can get into Foxpro, you can just export the data into a .csv file.

There are lots of dbf utility programs you can use to convert to other formats.



____________________________
JustKIDn

____________________________
Families can be together forever...