Excel: Send multiple values in "Command text"

Question

Located in the "Data > Connections > Properties > Definition (tab) > Command text", I have the following:

{Call SP_calculo_algo(?)}

Command Text

Where currently the function receives only one value through the unique parameter that it has, that according with someone told me it is represented by the character of the question mark (?).

What I need is to send two (2) values through the function, since I have the SQL query that returns data that refer to a range between two dates. For example: Start Date (parameter 1) and End Date (parameter 2).

Can you help me?

Hi there, what kind of database are you connecting to (SQL Server, MySQL, Oracle, etc...)? — Lloyd Banks, Jan 15 '13 at 22:40

score 12 · Accepted Answer · answered Jan 15 '13 at 23:09

12

Make sure you are using Microsoft Query for your connection.

Data -> From Other Sources -> From Microsoft Query

At the end of the Wizard, make sure you specify "Return data to Microsoft Excel".

After the query executes, the data will be on your worksheet. Click somewhere on the result set, then select the query Data -> Connections -> Properties.

Click on the definition tab. Modify the command text to include the query with question marks as placeholders for your parameters.

MS Query Parameters

Click OK, and you will be prompted for each parameter. Click the box if you want to save the value you enter for future refreshes.

Prompt for MS Query Parameter

answered Jan 15 '13 at 23:09

Jon Crowell

21,695
14
89
110

1

Nothing to do with the question but thank you for this, just saved me a ton of code – Jesse Aug 21 '13 at 18:38
1

Why isn't the microsoft documentation itself so helpful? Thanks :) – MarkNS Feb 17 '15 at 14:42
I tried to do the same but it is non editable mode. How to do it now – Jagadesh Apr 22 '15 at 10:06

Excel: Send multiple values in "Command text"

1 Answers1

Linked