sql - How to export the results of a stored procedure directly to a MS Excel file? -

text after "itemprop =" text ">

I found a way to extract the content of an MS SQL table to get the (sharp) excellence directly. But I do not know how to do this with a stored procedure that requires parameters, is it possible to extract the results of a stored procedure in Excel? I know how to do this indirectly (using the data table), but it is very slow Thanks a lot.

PS: This is the method that I was using to do some tests. It works with a table, but what I need to do is to get the result of a stored procedure:

  private sub SqlToExcelTest2 (ByVal excelFilePath as string, _ ByVal nonExistingSheetName string In the form of _ ByVal as the SQLServer string, _ ByVal sqlDatabase string, _ ByVal as sqlUserName string, as _ ByVal sqlPassword string, as _byVal as sqlTable string) excelConnStrTemplate string = "Provider = As Microsoft.Jet.OLEDB.4.0, data Source = {0}; Expanded Properties = "" Excel 8.0; HDR = Yes; IMX = 2 ";" connStr Dim String = String.Format (excelConnStrTemplate, _ excelFilePath) Const as adoQueryTemplate String = "as Select * Execution {0} from [ODBC, Driver = {{SQL Server}}, "& Amp; _ "Server = {1}; database = {2}; uid = {3}; pwd = {4}]. [[5}]" slow query string = string.format (endowttttpplate, _nonfinestinationgate name, _sqlServer , _ SqlDatabase, _ sqlUserName, _ sqlPassword, _ sqlTable) using OleConn as new OleDb.OleDbConnection (connStr), oleCmd as new OleDb.OleDbCommand (query, olecon) oleConn.Open () oleCmd.ExecuteNonQuery ( ) After the end sub