Running a SQL Stored Procedure in Excel without VBA

[qadeerahmed]

Superb effort Dear Wilson, it resolves my parameter passing of date from excel, hats off to you .

[viswaarun]

Dear Sir, You are a very good teacher. The way you make the viewer understand the process step by step is appreciable. I look forward to viewing your other videos in this subject. Thank you very much.

[bensalazar]

This is amazing thank you so much, now I got to learn how to deploy this and scale it out

[selbykgatuke]

Thanks a lot for this. Excel is a critical part of our software solutions ! ! !

[zulemapacheco]

Excelente he estado batallando durante semanas!!! y usted me ayudo un mundo, mil gracias!! :)

[TheDistractionStudio]

Thank You Very Much! Very informative and helpful

[elijahjns]

Okay, this is the video I was hoping to find. Thanks!

[shannonwoodcock]

Is there a way to get multiple tables from the stored procedure? I would like to get each table to its own tab in excel.

[nitincsawant]

Hats off...!!! You have explained it very neatly. Thanks for all your efforts.
1. I was trying to follow the exact same thing you dictated in your video.
2. However, when I try to click "From Other Sources" in EXCEL, and clicked on Microsoft queries, it did not show me the ODBC connection I created before going in EXCEL
3. I went ahead and clicked <New Data Source> in Databases window and gave the name of the data source and chose "SQL Server Native Client 11.0" and tried connecting it. Connection was successful
4. However, when I clicked SQL, and coded {call SPNAME(?, ?)}, it says, Store Procedure cannot be found.
I tried doing many combination, this error still persists...can you please guide.

[chiknaladka]

Thanks for the video. I saw dexterity dictionary in your task bar. Which version you are using currently ?

[sanjayism]

it is not working for MySQL . i use statement as {call.procedure1(?)}. it showing syntex error

[suryatshelke]

If time column is there, can we get data by some time interval, like after every 5 min, 10 min with order from date and order to date. Will this possible?

[alisarip]

Could you please make other video like this using mysql server?

[GatoLocoMx]

how can I pass a parameter with more than 1000 characters ? without having to cut the parameter into many parameters and concatenate them

[pinkbeautytwinkle]

How does the query know that FromOrder Date corresponds to Order Date and ToDate corresponds to Due Date?

[akshayk]

I have query but can't put parameters in it, parameters can't be insterted in query that can't be displayed graphically: need solution
Select z.Docno, z.date, z.item
From
(Select To.docno, to.date, t1.item
From table To join table1 t1
Where date between ? And ?
Group by to.docno, to.date, t1.item
)Z
Group by z.docno, z.date

[mohammedaijazsiddiqui]

But I receive an error when I pass parameter stating- error converting data type nvarchar to date

[tmechldtc]

This man is a legend! Where can I donate ??