MySQL Forums :: Microsoft Excel :: Microsoft Excel and MySQL: Articles, Blogs

MySQL for Excel:
- Docs: http://dev.mysql.com/doc/mysql/en/mysql-for-excel.html
- Forum: http://forums.mysql.com/posting.php?171
- https://blogs.oracle.com/MySqlOnWindows/entry/introducing_mysql_for_excel
- https://blogs.oracle.com/MySqlOnWindows/entry/how_to_guide_to_importing
- http://mysqlblog.fivefarmers.com/2012/11/08/using-mysql-for-excel/

http://net.tutsplus.com/tutorials/php/how-to-generate-a-complete-excel-spreadsheet-from-mysql/


http://helpdeskgeek.com/office-tips/excel-to-mysql/
http://blog.tjitjing.com/index.php/2008/02/import-excel-data-into-mysql-in-5-easy.html
http://blog.mclaughlinsoftware.com/microsoft-excel/accessing-to-mysql/


Apple Mac OS:
http://blog.mclaughlinsoftware.com/2011/02/27/excel-2011-query-mysql/
http://blog.mclaughlinsoftware.com/microsoft-excel/excel-2011-mysql-config/
http://blog.mclaughlinsoftware.com/2011/02/10/mac-os-x-mysql-install/
http://blog.mclaughlinsoftware.com/mysql-databas/mysql-connector-odbc/


Python and Excel:
http://packages.python.org/openpyxl/
http://scienceoss.com/read-excel-files-from-python/
http://scienceoss.com/write-excel-files-with-python-using-xlwt/
http://www.python-excel.org/
http://pytools.codeplex.com/wikipage?title=Pyvot
http://packages.python.org/Pyvot/
http://pypi.python.org/pypi/Pyvot
http://pyxll.com/
https://datanitro.com/


PHP and Excel:
https://github.com/PHPOffice/PHPExcel



Excel-to-Database
http://leansoftware.net/en-us/products/exceltodatabase.aspx



Edited 11 time(s). Last edit at 12/07/2012 02:52PM by Edwin DeSouza.