Forum Discussion

Copper Contributor

Oct 27, 2020

Running SQL Queries in Excel

I've used ODBC queries in Excel before but it was always with stored procedures on the server. Now I'd like to be able to define freeform SQL queries in Excel that pull data from a MS SQL Server. I h...

BI & Data Analysis

excel

Wyn Hopkins

MVP

Oct 28, 2020

Hi Dave7

The best way to pull data from a SQL Server is to use Power Query in Excel, have you come across that yet?

Dave7

Copper Contributor

Oct 28, 2020

Thanks, Wyn Hopkins. I should have said that yes, I got into the Power Query but couldn't figure out how to use it to write plain SQL. The Advanced Editor it has seems to use a different language (PowerQuery, apparently). Is it just not possible to write plain SQL? If that's the case, I'm sure I can figure out PowerQuery though if you have a good primer I'm all ears.