Run an SQL Query With Dynamic Parameter from Excel

Run an SQL Query With Dynamic Parameter from Excel
Running SQL from Excel with dynamic parameters
Truy vấn dữ liệu từ SQL Server từ excel với tham số

Bạn để lại comment nếu có thắc mắc hoặc có vấn đề cần giải quyết
Nếu video hữu ích thì nhớ like để khuyến khích mình nhé

Thanks for watching!
Please like, share and comment below.
Subscribe to my channel for more!

[smplfy]

Some people need a non-VBA way to do this. I'm seeing half-explanations for using Power Query, but no one is hitting it out of the park in terms of being clear and succinct. While this is as close as it comes, this is VBA-based.

[zm]

I'm getting 438 Runtime error, it is highligting SQL statement. Not sure but maybe i need to declare variable? You put Process in your sql and it reads it. Or is it workbook versus worksheet error?

[UnSF-]

What if query has multiple joins and filters data using date and subjective stuff? How to set parameters for the samw

[goingolfn]

do you have the source file for this somewhere. It is very blurry resolution.

[carlosagudelo]

How can i used this with a Store Procedure, can u help me?

[danielgamez]

Thanks. However, a voice explanation instead of that lame music would be better.

[tessmanak]

I can neither see because the screen back ground is to bright white. Also, the music is very distracting.-sorry