2

How to fetch data from MySQL database table into Excel?

Improve this question
1
  • are you talking about exporting to excel??? Commented Apr 19, 2011 at 10:41

5 Answers 5

Reset to default
8

  1. Install Connector/ODBC

  2. Create an ODBC DSN (Control Panel / Administration / ODBC if on Windows)

  3. Import data using Microsoft Query (Data / External Data / From Other Sources / Microsoft Query in Excel 2007)

Improve this answer
Sign up to request clarification or add additional context in comments.

Comments

2

If your server is also your client machine you can do

select * from table1 into outfile 'c:/path/outfile.csv'

(Note the use of forward slashes even on Windows)

If your server is a remote machine, make sure your have the MySQL client software installed on the client machine and do:

mysql -e "SELECT * from table1" > file_name

You can then open the csv file in Excel.

Improve this answer

Comments

2

Try out with 

SELECT column1, column1, column1 from tablename INTO OUTFILE "path/CSV/tablename.xls" FIELDS TERMINATED BY "," OPTIONALLY ENCLOSED BY '"' LINES TERMINATED BY "\n" <br>

refer http://dev.mysql.com/doc/refman/5.1/en/load-data.html

Improve this answer

Comments

1

I think the easiest way is ODBC. You can download the ODBC driver for MySQL (if you don't have it already). Then, once inside Excel, you can go to "Data-> Obtain external data" (the name and location of the menu items may vary) and pick or create a data source.

Improve this answer

Comments

0

odbc-query.

excel: /data/get external data...

Improve this answer

Comments

Your Answer

By clicking “Post Your Answer”, you agree to our terms of service and acknowledge you have read our privacy policy.

Start asking to get answers

Find the answer to your question by asking.

Ask question

Explore related questions

See similar questions with these tags.