Yes,  the question and answers do not match.  That can only be the true answer.

Additional suggestions:
(1) Save spreadsheets as csv or text first and then use import wizard: more options for data type conversions in wizard when importing csv or text files, also avoids ACE driver...

Another observation: The join between the contractskill and users tables is missing from the stored procedure code posted -

"FROM DBO.contractskill

INNER JOIN DBO.users

INNER JOIN DBO.contract

ON DBO.users.userid = DBO.contract.userid"

Microsoft Query has its quirks. Try hard-coding the year value at first, for example: {Call YourProcedureName (2016)}. Don't enclose 2016 in single quotes. Return result to Excel worksheet.

Then...

For context please refer to link given by Shawn Melton.

Essentially you link a parameter to a spreadsheet cell reference which contains the value of the parameter. You can then...

To store the vba code you can record a macro. You can then assign the macro to a key or button. The Macro menu is on the View tab or...

Thanks for an interesting helpful article.

Thanks Wayne. Good introductory article.

I don't know whether the following might meet your needs: Create an ODBC connection to Sql Server using ODBC manager within Excel, then use the Data Import menu in Excel...

Thanks for a useful article, clearly explained. I shall have occasion to use your method when I import data from Excel, which despite precautions has duplicates.

I've moved over to e-books (1) because they are less expensive and (2) easy to download and use immediately. I much prefer PDFs, which are closer to printed book...

Yes, very good start. Like the interactive approach.

You could also use MSQuery via the Data Import menu from within Excel 2003. First create a simple select query to create link to destination cells, then edit the query...