How to Solve Linear Equations in Excel

How to Solve Linear Equations in Excel Using the MINVERSE and MMULT Functions Systems of linear equations pop up everywhere you look. Small retail shops want to maximize the profit from the distribution of goods taking up limited shelf space. Chemists need to balance constituents of a complex reaction. Economists are compelled to build models; […]

Using OPENROWSET to Read Excel Worksheets from SQL Server: Part 2 – How to Define and Query a Linked Server

In my last post we looked at how to set up the system to use OPENROWSET to read Excel Worksheets from SQL Server. I believe that using the OPENROWSET function is the most flexible and practical method for linking Excel worksheets to SQL Server. Before we look at OPENROWSET, however, let’s take a moment to review […]

Using OPENROWSET to Read Excel Worksheets from SQL Server: Part 1 – How to Set Up the System

Julia P. from the Learning Tree Transact-SQL Programming course writes “I’ve tried to use the OPENROWSET function to query Excel files, but I keep getting the same error. No matter what I try, SQL Server responds with “OLE DB provider “Microsoft.Jet.OLEDB.4.0” for linked server “(null)” returned message “Could not find installable ISAM.”.” Hi, Julia. Unfortunately,lots […]

How to Write DAX Summary Queries In Excel Using PowerPivot: The SUMMARIZE Function

In the previous segment, we saw how to write DAX statements in Excel to query Power Pivot Data. In this segment, we will take a first look at the SUMMARIZE function. While the DAX queries discussed here could be executed in the Management Studio against an Analysis Services tabular mode database, here we will be […]

Writing DAX Summary Queries Using PowerPivot and Excel QueryTable Objects

Don’t get me wrong. Excel PivotTables are one of the best things since pizza and beer. (And considering how much I enjoy that particular combination of snack and beverage, that’s really saying something.) Nevertheless, there are times when you want to take full control, write your own DAX query, and display the results in a […]

Type to search blog.learningtree.com

Do you mean "" ?