Is there any way to transfer Mysql data directly to an Excel table?

Asked

Viewed 1,310 times

7

Is there any way to transfer all data from the database to a table in Excel? It can be with any language.

mysql excel

  • Check to see if it helps you https://blogs.oracle.com/MySqlOnWindows/entry/how_to_guide_to_importing

  • You need exactly what? A function on a possible system that does the import to excel?

  • Good morning friend, the excel itself has the option to export to CSV. After opening Voce can save with xls.

2 answers

5


You can export to CSV (separated data with comma), which Excel opens normally. If you are using Phpmyadmin, it has a unique option for this export.

If you are using the Mysql Workbench tool, at this link teaches step-by-step how to export.

Or by command line would look like this:

SELECT * FROM bancodedados.tabela
INTO OUTFILE 'arquivo.csv'
FIELDS TERMINATED BY '|'
ENCLOSED BY '"'
LINES TERMINATED BY '\n';

1

Easy friend, Install this version or higher from Mysql make sure to install Mysql For Excel and ready, inside Excel 2007 or higher at the end of the DATA tab you will find a new button Mysql For Excel just configure the connection and enjoy the benefits!

Browser other questions tagged mysql excel

You are not signed in. Login or sign up in order to post.