Is it possible to transfer MySQL data directly to a table in Excel?

7

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

    
asked by anonymous 17.09.2015 / 04:09

2 answers

5

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

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

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';
    
17.09.2015 / 12:51
1

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

    
26.11.2015 / 03:12