A Visual Guide to Importing and Exporting Data Between Microsoft Excel and MySQL

In early 2009 we conducted our annual survey and what we found is that 66% percent of those surveyed used Windows for development and 48% ultimately deployed into production on Windows. Given that so many users deploy MySQL on Windows for production, it makes sense to recap how easy it is to work with data in MySQL and Microsoft Excel. With the power of the SQL language and MySQL’s RDBMs capabilities, it 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. For the purposes of this guide we will show you how easy it is to import and export data from MySQL and Excel using MySQL’s ODBC Connector in conjunction with Excel 2007 and Access 2007’s native import/export capabilities.