Microsoft Query won't let me edit parameter types for my SQL procedure.
To create parameters in a SQL stored procedure and set the data types:
- On the File menu, click Execute SQL.
- In the SQL statement box, create your query using fixed arguments for the procedure, and then click Save.
- On the View menu, click SQL.
- In the SQL statement box, replace each fixed argument with a question mark (?).
- Click OK, and then click Parameters on the View menu.
- To change the data type for a parameter, click the parameter and then click Edit.