By powerpivotgeek (dwickert@microsoft.com), on August 18th, 2010
Ok. I’ve promised some best practices – here is my first one.
What is the 2010 Office ACE provider and why is this important to PowerPivot? The 2010 Office System Driver for Data Connectivity Components (aka the Office ACE provider) is a OLE DB provider that can be used to read data from and write data to Office 2010 system files such as Microsoft Access Beta (mdb and accdb) files and Microsoft Excel 2010 (xls, xlsx, and xlsb) files. You can also use it to access text files.
Click through to continue reading Working with the 2010 Office ACE provider
