EXCEL 2007
Hey guys,
So heres my problem...
I wrote a SQL query without using the wizard or ms query. It connects to a SQLOLEDB. Now all I need to do is add a couple parameters to be defined from within the workbook. I cannot get the parameters option to not be grayed out under connection properties.
Supposedly when you put a question mark into the command text it should propt you to define the parameter. When I run the simple query attached I just get an error stating that the param is not defined.
What should I do?
Thanks
-Chris
Bookmarks