Querying SQL Server Data in Excel with a Parameter

The title is misleading. You are not affecting the sql query at all, you are only filtering AFTER more data than necessary had been pulled already.
I was expecting you showing how to use a parameter as part of the sql query itself.

The problem i ve is that my data is so big it can't even be loaded to excell..

yeah but what if you want to parameterize the sql query itself. like I have a SQL query SELECT * FROM ORDERS WHERE ORDERDATE=@ORDERDATE. I want to set the ORDERDATE from another cell in Excel. How does one do this?

what version of excel are you using?

Very intrsting. Would you happen to post another video on how to connect parater to a cell ?

Hi Did you do the next video as I cannot find it?

Thanks for the video! IS it possible to call a stored procedure with parameters?

Querying SQL Server Data in Excel with a Parameter can you send me the next link

This is the worst tutorial -- it doesn't do the one thing it is titled as doing.

This is not really querying with a parameter, it's filtering AFTER querying

Very helpful. A link to the next video in the series would be helpful. I'm looking how to call a stored procedure using these parameters.

How did Microsoft manage to make it so painful to connect a cell as a parameter to a query?

They really do get away with murder. Apple should write all the software which interacts with users.

Hello, this is really helpfull. Sorry, where is the next video from this series? I need to connect the Parameter in Power Query to a cell in Excel. Thanks!