Display return of a SQL query in Excel

0

My question is divided into two parts. The first one, it is possible to perform SQL command by Excel, as I need to display certain information from my MySQL database in a table in Excel.

Note: I do not want to connect via ODBC, I need the query to be performed via the same SQL command.

And the other part of the question, if it is possible to perform the SQL command, where do I do it?

    
asked by anonymous 07.04.2017 / 14:37

1 answer

2

Good morning,

You can perform SQL commands from Excel == > Yes, through Microsoft Query. See the Ribbon, Data group, connections from other sources, Microsoft Query.

If it is possible to perform the SQL command, where do I do it? == > Inside Microsoft Query. You can edit the SQL Query directly on the "SQL" button on the toolbar. You can also save SQL queries to ".qdy" files to execute them more quickly.

On the note: Yes, you need the MySQL ODBC Driver.

    
07.04.2017 / 14:43