Please start any new threads on our new site at https://forums.sqlteam.com. We've got lots of great SQL Server experts to answer whatever question you can come up with.

 All Forums
 General SQL Server Forums
 Database Design and Application Architecture
 problem with calling stored procedure from excel

Author  Topic 

mbbraunb
Starting Member

3 Posts

Posted - 2015-04-10 : 19:58:30
I have an excel workbook that is used to do complex calculations using macros. It is very slow in VBA and I want to move the heavy lifting to SQL. I need to pass inputs from Excel into SQL. I can use an OPENROWSET query in SQL to read in the data, but when I try to call that same query from the excel workbook containing the data, the connection times out. If I put the data into a separate excel file and instead pass that file path to the stored procedure, it works just fine. Does anyone know how to resolve this conflict?
   

- Advertisement -