Visual Foxpro访问mySQL数据库 [英] Visual Foxpro to Acess to mySQL Database

问题描述

今天我们为我的工作完成了名为记录管理系统的系统，这是一个替代品，或者我称之为替换。 （我只是想分享一下：D）



现在最后一个阶段是转移数据，但这里是旧系统以来最悲伤或最糟糕的部分几乎在1980年使用的记录几乎达到21507，包含它的表有57个字段。



我们需要将所有这些数据传输到MySQL数据库所以可以我这样做？



我的转帐方式有两种方式



1.转发数据将Fox专业版数据库导出到.xls（Excel文件）但是在我这样做之后，一些数据丢失了吗？



2.我在访问中传输数据的方式是还包括两种方式。



2.1）我通过（.dbf）格式导出foxpro数据库传输数据然后我去访问点击导入然后使用Micro Fox亲驱动程序然后浏览.dbf文件，但之后数据与我之前导出的数据不一样（我的意思是行不一样）



2.2）我的第二种传输方式是通过获取链接数据与上面相同的程序并传输数据，我不知道是否所有数据都是复制但是当我将数据复制为本地表和数据时出现错误（Microsoft ODBC Foxpro错误）类似的东西。



i在网络上搜索只是为了得到正确的解决方案，但最后我最终在这里发布了我的问题。



顺便说一句，我也下载了应用程序，但没有任何反应。





我希望我的合作程序员在这里帮助我。



欢迎提出任何建议谢谢：D

解决方案

Foxpro到Excel / Access是最重要的。 Excel /访问mysql很简单。



您忘了在问题中包含完整的错误消息。检查这些

将数据导入Microsoft Excel Visual FoxPro数据库 [ ^ ]

导入Visual FoxPro数据到Microsoft Access [ ^ ]

我找到了一个直接的开源， foxpro2mysql - 将Foxpro数据库转换为MySQL [ ^ ]。

尝试使用Google获取更多开源资源&的解决方案。

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

解决方案

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.

这篇关于Visual Foxpro访问mySQL数据库的文章就介绍到这了，希望我们推荐的答案对大家有所帮助，也希望大家多多支持IT屋！