Display return of an SQL query in Excel

Asked

Viewed 165 times

0

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

Observing: I do not want connection via ODBC, I need the query to be performed via SQL command itself.

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

mysql sql excel

1 answer

2


Good morning,

it is possible to perform SQL command by Excel ==> Yes, through Microsoft Query. See in the Ribbon, Data group, connections from other sources, Microsoft Query.

if it is possible to perform the SQL command, where I perform it? ==> Within Microsoft Query. You can edit the SQL Query directly from the "SQL" button in the toolbar. You can also save SQL queries to ". qdy" files to run them more quickly.

On the note: yes, you need the Mysql ODBC Driver.

  • And just one question, I can put values from an excel table field in these Querys?

  • Look I’ve never done this, but it seems so, see https://support.office.com/en-us/article/Customize-a-parameter-query-addf7cb7-ddf0-442f-a60c-cd7280e201bd (applies to Excel 2007)

Browser other questions tagged mysql sql excel

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