Table in Excel from SQL Server stored procedure with parameter field in workbook - Stack Overflow

I need to create a dynamic report using Excel and SQL Server. Going off of previous ones created by others I figured out how to create the data connection and use the stored procedure with a specific parameter in the connection properties definition tab.

The other reports use a? Select the Data tab on Excel's Ribbon, then within the Get Exernal Data group choose the "From other Sources" drop-down. Then Choose "From Microsoft Query".

Passing table valued parameters in SQL Server - TechRepublic

Be sure to include the squiggly braces around the call statement. If your stored procedure calls for more or less parameters, add or subtract question marks as needed. Hit the OK button.

Insert (Upload) XML file Data into SQL Table using Stored Procedure in husoxupowoj.web.fc2.com using C#, husoxupowoj.web.fc2.com

A question box should pop-up saying "SQL Query can't be represented graphically, continue anyway? You will now be asked for sample parameters for each question mark you included above. Enter valid parameter values for the data you are querying. Once you have entered the last parameter, you should get some results back in Microsoft Query. If they look good, close Microsoft Query. You should now be looking at an "Import Data" pop-up.

Click the Properties button, which will bring up the "Connection Properties" pop-up. Select the Definition tab, then select the Parameters button. You should now see a "Parameters" pop-up, where you can connect the parameter to a specific cell.

Select Get the value sql stored procedure parameter table variable the following cell, and then connect to an appropriate cell sql stored procedure parameter table variable Excel that will hold your parameter, by clicking the little box with the arrow. If you want the data to refresh every time you change the cell containing the parameter, check the box stating "Refresh automatically when cell value changes".

Continue as above for the other parameters. When finished, click OK, to return to the Connection Properties pop-up. Click OK to return to the Import Data pop-up, and click OK again. By posting your answer, you agree to the privacy policy and terms of service. Stack Overflow Questions Developer Jobs Documentation beta Tags Users. Sign up or log in to customize your list. Tour Start here for a quick overview of the site Help Center Detailed answers to any questions you might have Meta Discuss the workings and policies of this site About Us Learn more about Stack Overflow the company Business Learn more about hiring developers or posting ads foreks4yu trade binary options us.

Log In Sign Up. Join the Stack Overflow Community. Stack Overflow is a community of 7. Join them; it only takes a minute: Table in Excel from SQL Server stored procedure with parameter field in workbook Ask Question. How do I do that too?

I got it to work using the steps provided at the following linked blog post. Then Choose "From Microsoft Query" Within "Choose Data Source" pop-up box, select your SQL Server, then hit OK. Close the "Add Tables" popup if necessary.

Enter the following syntax: If you want the data to refresh every time you change the cell containing the parameter, check the box stating "Refresh automatically when cell value changes" Continue as above for the other parameters. You should now have some data straight from your stored procedure. The only choices showing in step 2 "Select your SQL server" are "New Data Source", "dBASE Files", "Excel Files" and "MS Access Database". I really wonder how you guys made it work I haven't had to use this in 3 years.

I only had it work in Excel Are you using a newer version of Excel? RickNo You need to add your Server as an existing dsn connection and then when that box appears, click browse, find your dsn file and that's it! Sign up or log in StackExchange.

Sign up using Facebook. Sign up using Email and Password.

Post as a guest Name. Stack Overflow works best with JavaScript enabled. MathOverflow Mathematics Cross Validated stats Theoretical Computer Science Physics Chemistry Biology Computer Science Philosophy more 3. Meta Stack Exchange Stack Apps Area 51 Stack Overflow Talent.