Run an SQL Query With a Parameter from Excel 2.Dunno why MS has made this so complicated, You will have to use Microsoft Query.Click on Data From External Sources From Microsoft Query.CHoose Data source comes up.Select SQL Server, enter the Auth details, and select the table.Click on Next, dont select any filtering criteria, choose sort by criteria, click on next.Now, click on ViewEdit in MS Query instead of selecting Return to Excel.Click on Finish. Now in MS Query, Click on Criteria Add Criteria, choose the operator and let the value be Click on File return data to Excel. How To Download Adobe Flash Player On My Wii Remote on this page. Now Excel should prompt you for the parameter, select the relevant cell.To edit the parameters, click on Data Properties Finger icon Definition parameters.You can also use the SQL query editor and type in the query with the joins and put a
0 Comments
Leave a Reply. |
AuthorWrite something about yourself. No need to be fancy, just an overview. Archives
November 2017
Categories |