Exporting data from excel to mysql

Posted on 2013-12-18
Medium Priority
Last Modified: 2013-12-19
Exporting data from mysql to excel - are you limited to the constraints of mysql?

Is this not intended for exporting full excel documents to mysql?
Question by:burnedfaceless
1 Comment
LVL 33

Accepted Solution

snoyes_jw earned 2000 total points
ID: 39728050
There are several ways to get data from MySQL to Excel.
The mysql command line tool can generate tab-delimited output. You can redirect that to a file, then open it with Excel.
Use the "MySQL for Excel" plugin - http://www.mysql.com/why-mysql/windows/excel/
Install MyODBC and use Excel's ability to pull data from any ODBC source.
MySQL has a CSV storage engine. The CSV files it creates can be opened and edited directly with Excel.

Going the other way, from Excel to MySQL, can use some of the same mechanisms. But you usually have to set up the table in MySQL first, and make sure that your Excel data is in a form that matches the data types of the MySQL table.

Featured Post

Free Tool: Port Scanner

Check which ports are open to the outside world. Helps make sure that your firewall rules are working as intended.

One of a set of tools we are providing to everyone as a way of saying thank you for being a part of the community.

Question has a verified solution.

Are you are experiencing a similar issue? Get a personalized answer when you ask a related question.

Have a better answer? Share it in a comment.

Join & Write a Comment

Microsoft's Excel has many features that most people will never need nor take advantage of.  Conditional formatting is one feature that you may find a necessity once you start using it.
In this blog, we’ll look at how improvements to Percona XtraDB Cluster improved IST performance.
This Micro Tutorial demonstrates using Microsoft Excel pivot tables, how to reverse engineer competitors' marketing strategies through backlinks.
How can you see what you are working on when you want to see it while you to save a copy? Add a "Save As" icon to the Quick Access Toolbar, or QAT. That way, when you save a copy of a query, form, report, or other object you are modifying, you…

624 members asked questions and received personalized solutions in the past 7 days.

Join the community of 500,000 technology professionals and ask your questions.

Join & Ask a Question