Click here to Skip to main content
15,921,837 members
Please Sign up or sign in to vote.
0.00/5 (No votes)
See more:
Today we have done our system called Records Management System for my work, this is a substitute or I rather call a Replacement. (I just wanna share :D)

Now where on the last phase which is the Transferring of data but here is the sad or the worst part since the old system has been used for almost 1980 the records reach almost 21507 and the table that contains it has 57 fields.

We need to transfer all of this data to MySQL Database so what can i do?

My way of transferring is consist of two ways

1.Transferring the data by exporting Fox pro Database to .xls(Excel files) but after i did this some of the datas was missing?

2. My way of transferring of data in access is consist of two ways also.

2.1)I transfer the data by exporting the foxpro database by (.dbf) format then i go to access click import then use Micro Fox pro Driver then browse the .dbf file but after that the data was not the same as i exported earlier (I mean the rows are not the same)

2.2)My second way of transferring it is by getting link data same procedure as above and the data was transferred, I dont know if all the data was copy but when im copying the data as local table and data there is an error (Microsoft ODBC Foxpro error) something like that.

i have search all around the net just to have the right solution but in the end i ended up posting my problems here.

by the way i have also downloaded applications but nothing happens.

I hope my Co-Programmers help me here.

Any suggestions are welcome Thank you :D

1 solution

Foxpro to Excel/Access is the big deal. Excel/Access to mysql is easy one.

You forgot to include complete error message in your question. Check these
Importing Data into Microsoft Excel from a Visual FoxPro Database[^]
Importing Visual FoxPro Data into Microsoft Access[^]
And I found an opensource for direct one, foxpro2mysql - Convert Foxpro database to MySQL[^].
Try Google for more opensources & solutions.
Share this answer
Maciej Los 23-Dec-13 6:50am    

This content, along with any associated source code and files, is licensed under The Code Project Open License (CPOL)

CodeProject, 20 Bay Street, 11th Floor Toronto, Ontario, Canada M5J 2N8 +1 (416) 849-8900