calling a stored procedure on MS SQL Server within MS Excel 2000

  • Thread starter Witold Domienik
  • Start date
W

Witold Domienik

Hi everybody
I prepared a pivot table report based on an external database source (a table on MS SQL Server 2000).
Now I would like to add a button which will call a stored procedure on the server (procedure recalculating data in above table) and than will refresh the pivot table.
Regards
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Similar Threads

Embedding excel formula in MS Query that will be evaluated in excelnot in the SQL server 0
SQL Server Stored Procedure 5
Best way to call a SQL Server Stored Procedure from within Excel 2
import Excel worksheet to SQL Server table 7
calling a stored procedure on MS SQL Server within MS Excel 2000 2
VBA to export large tables from Excel to SQL Server 1
Joining SQL Server Stored Procedure to SQL Server Table 2
VBA SQL Server Stored Procedure creating a Pivot Table 7

Top