Call Stored Procedure with multiple parameters from Excel

Call #StoredProcedure with multiple parameters or different parameter values from #Excel

#SQLwithManoj

SYNTAX: {CALL uspGetManagerEmployees (?)}

[email]

This is great! I have always done this using complicated VBA code. This works so much better and is much easier to set up. Thanks!

[chadsterling]

Thank you, Thank you! you just saved me so much time. Thank you so much. This is exactly what i needed and i definitely wouldn't have been able to figure it out on my own. Thank you!!

[bikerlife]

Thanks for documenting! It's surprising how difficult MS made this considering both are major MS products and it should be simple task.

[ericamaya]

Very clear explanation. Thanks a lot !

[dimaxx]

When Parameter cell is specified, check "Refresh automatically when cell value changes", so there is no need in clicking Refresh every time.

[mrgreenteatime]

Hi,
thank you for nice tutorial.
Would the similar method work for an array of records (like list of products) from within an excel? For example using user-defined table paramenter passing into store procedure ?

[amoscookie]

my understanding is how does "CALL" works when Call is not part of T-SQL but ODBC ? How did you manage to use MS Query and run it without error s ? Pls advise.

[grillingo]

SI el parámetro es fecha, mejor es recibir en sql un texto y convertirlo a fecha en el SP, en Excel la celda debe tener formato texto.

[makali]

What if we have more than 1 parameter how to use (?), or what for next one please help

[ravisrikakulapu]

Hi, how to get required rows by a condition over the stored procedures? which is not mentioned in parameter while creating a stored procedure

[mariorivera]

Great Video! I have a question. How can you pass a NULL value from Excel into one of the Store Procedure variables? What value from Excel will SQL see as a NULL? For example, if I run the Procedure from within SQL Server, the four variables will look like this: EXEC spMLR_CustSalesSummary 40109, NULL, NULL, '7'1'2021'. I need Excel to feed the 2nd and 3rd the same NULL value.

[priyal]

How to automate this for monthly reports?

[pearlking]

How to do if I need to pass multiple values from a single excel cell?

[akostova]

Is this possible with table valued functions?

[lexxx]

Hi I have a problem. When I run sp in Excel with parameter it imports only integer columns from Sql server stored procedure output. For date and nvarchar columntypes it imports blanks. Does anyone know solution for this?

[hubertasuncion]

holy shit this is amazing! how does the ms sql server know how to connect to the excel? sorry im new to this. i have an existing sql query that i want to update excel data using call stored procedure

[Ashirbadratha]

I want a stored procedure to read records from the excel and extract the data from the excel rows, and execute the query by passing these data as an argument and insert data to sql.

[ctk]

What if there are multiple parameters ?

[albaavila]

Hi,
Your video is great. I liked. Thank you for you video!
I have a query if possible to answer me. I made a stored procedure in SQL 2012, with two date type parameters.
In SQL it works correctly. In Excel gives me problems. When I try to do what you did in your video, it gives me an error. I give you two parameters. It seems that it only recognizes one parameter. I did something like this: {CALL SPquery_user (?), (?)}
When I update, a message indicating "syntax error or access violation" appears. And if I write something like this: EXEC SPquery_user (?), (?) And refresh, a message appears stating "Invalid parameter number". I hope you can orient me to know what the error is. What I'm doing wrong? Thankful for the help you can give me.

[makstudio]

Hi Manoj, I want to add multiple parameters to SP, can you please tell me syntax for