MySQL Forums
Forum List  »  MySQL for Excel

Microsoft Excel and MySQL: Articles, Blogs
Posted by: Edwin Desouza
Date: July 18, 2012 02:21PM

MySQL for Excel:
- Docs: http://dev.mysql.com/doc/mysql/en/mysql-for-excel.html
- Forum: http://forums.mysql.com/posting.php?171
- Demo: https://blogs.oracle.com/MySqlOnWindows/entry/mysql_for_excel_main_features


- https://blogs.oracle.com/MySqlOnWindows/entry/introducing_mysql_for_excel
- https://blogs.oracle.com/MySqlOnWindows/entry/how_to_guide_to_importing
- https://blogs.oracle.com/MySqlOnWindows/entry/how_to_guide_to_exporting
- https://blogs.oracle.com/MySqlOnWindows/entry/how_to_guide_to_appending
- https://blogs.oracle.com/MySqlOnWindows/entry/mysql_for_excel_1_21
- 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 14 time(s). Last edit at 03/18/2014 10:00AM by Edwin Desouza.

Options: ReplyQuote


Subject
Views
Written By
Posted
Microsoft Excel and MySQL: Articles, Blogs
8614
July 18, 2012 02:21PM


Sorry, you can't reply to this topic. It has been closed.

Content reproduced on this site is the property of the respective copyright holders. It is not reviewed in advance by Oracle and does not necessarily represent the opinion of Oracle or any other party.