Pass Parameters from Excel SQL Query

[Jeffs23]

Question: I am trying to pass a Stored Procedure through a worksheet with the following SQL and getting this Error - "Parameters are not allowed in queries that can't be displayed graphically".

My code is this - EXEC cusExcelMTD, ?, ?

I have seen that I need to use VB to alter my excel spreadsheet but I have no clue as to how to do this or the coding. The two parameters I want to pass are "StartDate" and "EndDate". Can someone please lend me hand?

 

[ukmikeb]

Hi

Welcome to the forum.

I assume you're using Excel 2003 and Access 2003.

Prior to your execute statements you need :-

Dim conn as ADODB.Connection
 
Set conn = CurrentProject.Connection

and then your execute should read like :-

conn.Execute "EXEC  cusExcelMTD " & Startdate & ", " & Enddate

Good luck

Mike

 

[Jeffs23]

Opps I did forget to post what version I am on - Its actually 2007 on my local machine and my client is using 2003 and its not to access its to SQL server. Does this matter?

 

[xenou]

Can you describe more precisely how you are running this query, and what the data source for the query is? There's many ways to do these things and your post doesn't clarify the means by which you are running this query. Though, for what it's worth, EXEC looks like a SQL Server command to me too ...