Visual Foxpro to Acess to mySQL Database

Question

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

Posted 20-Dec-13 13:25pm

Crixalis Paul

Add a Solution

1 solution

Add a Solution

Add your solution here

Treat my content as plain text, not as HTML

Preview 0

…

Existing Members

Sign in to your account

...or Join us

Download, Vote, Comment, Publish.

Your Email
Password
Forgot your password?

Your Email
This email is in use. Do you need your password?
Optional Password

I have read and agree to the Terms of Service and Privacy Policy
Please subscribe me to the CodeProject newsletters

When answering a question please:

Read the question carefully.
Understand that English isn't everyone's first language so be lenient of bad spelling and grammar.
If a question is poorly phrased then either ask for clarification, ignore it, or edit the question and fix the problem. Insults are not welcome.
Don't tell someone to read the manual. Chances are they have and don't get it. Provide an answer or move on to the next question.

Let's work to help developers, not make them feel stupid.

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

thatraja · Answer 1 · 2013-12-23T00:26:00

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.