Updating access data from excel

09 Nov

While a pivot cache can handle much larger data sets, they are limited to using formulas available in pivot tables.

It is very important to keep data separate from the rest of your dashboard.Data Analysis Expressions (DAX) was also introduced in Excel 2010 and provides an extensive library of formulas that can be used in Power Pivot data sets.While DAX is not as rich as Excel’s native formula library, it is still rich enough for competent Excel users to get creative by combining DAX and native formulas to achieve their goals.The first is to import the whole data set and use native Excel features (Pivot Tables, filters, etc.) and formulas to produce the necessary results.This approach works fine if the data being placed in Excel is not too large.