I am pulling data from Oracle in Excel and was wondering if I could set an input for the query when using microsoft SQL
For example when the data is refreshed in Excel I was hoping that I could get a prompt asking me for an input such as a date or SKU reference #.
In Oracle I use something like:
where SKU = '&1'
But that same syntax doesn't work in MS SQL. Can anyone help?
Bookmarks