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

Our new SQL Server Forums are live! Come on over! We've restricted the ability to create new threads on these forums.

SQL Server Forums
Profile | Active Topics | Members | Search | Forum FAQ
Username:
Password:
Save Password
Forgot your Password?

 All Forums
 General SQL Server Forums
 Database Design and Application Architecture
 problem with calling stored procedure from excel
 Reply to Topic
 Printer Friendly
Author Previous Topic Topic Next Topic  

mbbraunb
Starting Member

USA
3 Posts

Posted - 04/10/2015 :  19:58:30  Show Profile  Reply with Quote
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?
  Previous Topic Topic Next Topic  
 Reply to Topic
 Printer Friendly
Jump To:
SQL Server Forums © 2000-2009 SQLTeam Publishing, LLC Go To Top Of Page
This page was generated in 0.01 seconds. Powered By: Snitz Forums 2000