Unable to Show the Data
I created a project with Excel 2007 data sources. When running one of my data-bound tests on a machine with Excel 2010, it fails with the following error:
Unable to show the data.
Error: The 'Microsoft.ACE.OLEDB.12.0' provider is not registered on the local machine.
I receive the same error when I attempt to bind the data from scratch. It fails to show the Excel Sheets in the Table drop-down menu in the Setup Binding menu.
Install Access Database Engine 2007 to resolve the issue. ADE 2007 and 2010 can coexist on the same machine, so you don't need to uninstall ADE 2010 if it's currently installed.