How to import Access and Excel into one of MySQL

Access|excel|mysql for some small and even medium-sized companies, still use Access or Excel to record data, not only slow, but also in many people to operate a lot of inconvenience, as the business development, they have to upgrade the system requirements, But they do not have a lot of money to develop a system, then use MySQL database, and then with PHP and other scripting language development has a lot of benefits, not only the economy, speed, easy to maintain, and through the browser can be more than one person to operate the database, can greatly improve the efficiency. But here comes the first question, how to import data from Access and Excel into MySQL, and take a specific project as an example of how to use VB to develop such a library guide program.

Project requirements: The company is a second-hand real estate trading company, the real estate information from several branch offices, stored in Access files and Excel files, requires all the data into a medium-sized database, and the realization of the property search function.

Project analysis: Considering the size of the company, the decision to use MySQL database, it is fully networked Cross-platform relational database system, but also has a client/server architecture of the distributed database management system. It has a strong function, easy to use, easy to manage, fast operation, high security and reliability, and so on, for small and medium-sized enterprises are very useful, search function can be implemented in PHP. As for the operation of data guide, it can be done through VB. This is highlighted below.

Software Environment: Server using Win2000 server,win2000 is more stable than Win98, and more controllable.

This article introduces the example is very simple, as long as you have developed ASP and visual programming has a little concept to understand, you can use VB to develop similar database applications.