database – Dynamic Query of a SQL table in Excel

database – Dynamic Query of a SQL table in Excel

Hmm try with vba execution on cell change maybe?

https://msdn.microsoft.com/en-us/library/office/ff821552.aspx

.CommandText = _ Select ProductID From Products Where &
Range(A1).value & = Range(A2).value

database – Dynamic Query of a SQL table in Excel

Leave a Reply

Your email address will not be published.