The Sun/MySQL white paper "A Visual Guide to Importing and Exporting Data Between Microsoft Excel and MySQL (login or registration required) discusses the process using MySQL’s ODBC Connector in conjunction with Excel 2007 and Access 2007’s native import/export capabilities.

The authors contend that it is easy to work with data in MySQL and Microsoft Excel. With the power of the SQL language and MySQL’s RDBMs capabilities, the solution allows users to leverage the data so that it can be shared by multiple users concurrently in a more secure, and manageable manner through a variety of interfaces and front ends.

The paper features numerous screen shots that constitute a visual guide on how to get started with importing and exporting data into Microsoft Excel. This can easily be accomplished natively with Excel or Access in combination with MySQL’s ODBC Connector, the paper asserts. The benefit of using MySQL in conjunction with Excel, means that data can be easily visualized, analyzed and manipulated in Excel, and at the same time can be made available to multiple users in a more secure and reliable manner through a variety of front ends, whether they be Access or browser-based.

The paper includes links to downloads of MySQL 5.1 GA, a A Visual Guide to Installing MySQL on Windows, the MySQL sample database Sakila and a link to the MySQL ODBC Connector.

Brief examples of companies making effective use of MySQL, such as Adobe and NetQoS, conclude the paper.

More Information

A Guide for Migrating from Microsoft Access to MySQL [...read more...]

		fullsource
Print Email Current Profile Archive Blog Generate newsletter