MDAC related errors when trying to export products to Excel

Hosting nopCommerce version 1.8 on a production VPS Windows 2008 x64 R2 server, and I get the following error when trying to export products to Excel:

The .Net Framework Data Providers require Microsoft Data Access Components(MDAC). Please install Microsoft Data Access Components(MDAC) version 2.6 or later.

A search in this forum did not yield any resolutions.

I also have a Windows 2008 R2 development server on my local network, and that installation of nopCommerce 1.7 produces the following error:

The 'Microsoft.Jet.OLEDB.4.0' provider is not registered on the local machine.

I do not seem to have this problem with an installation on a windows 2003 server.

Try:
http://www.microsoft.com/downloads/en/details.aspx?FamilyID=78CAC895-EFC2-4F8E-A9E0-3A1AFBD5922E
Remember: Backup, backup and then backup once more.

Thanks, Carl, but I've already tried that with no success. MDAC 2.8 will not install on a Windows 2008 64 bit system.

The additional information I see in the log page in the administration site is:

Log type:  AdministrationArea  
Severity:  11  
Message:  The .Net Framework Data Providers require Microsoft Data Access Components(MDAC). Please install Microsoft Data Access Components(MDAC) version 2.6 or later.  
Exception:  System.InvalidOperationException: The .Net Framework Data Providers require Microsoft Data Access Components(MDAC). Please install Microsoft Data Access Components(MDAC) version 2.6 or later. ---> System.Runtime.InteropServices.COMException: Retrieving the COM class factory for component with CLSID {2206CDB2-19C1-11D1-89E0-00C04FD7A829} failed due to the following error: 800736b3 The referenced assembly is not installed on your system. (Exception from HRESULT: 0x800736B3). at System.RuntimeTypeHandle.CreateInstance(RuntimeType type, Boolean publicOnly, Boolean noCheck, Boolean& canBeCached, RuntimeMethodHandleInternal& ctor, Boolean& bNeedSecurityCheck) at System.RuntimeType.CreateInstanceSlow(Boolean publicOnly, Boolean skipCheckThis, Boolean fillCache) at System.RuntimeType.CreateInstanceDefaultCtor(Boolean publicOnly, Boolean skipVisibilityChecks, Boolean skipCheckThis, Boolean fillCache) at System.RuntimeType.CreateInstanceDefaultCtor(Boolean publicOnly) at System.RuntimeType.CreateInstanceImpl(BindingFlags bindingAttr, Binder binder, Object[] args, CultureInfo culture, Object[] activationAttributes) at System.Activator.CreateInstance(Type type, BindingFlags bindingAttr, Binder binder, Object[] args, CultureInfo culture, Object[] activationAttributes) at System.Data.OleDb.OleDbConnectionInternal.CreateInstanceDataLinks() at System.Data.OleDb.OleDbConnectionInternal.GetObjectPool() --- End of inner exception stack trace --- at System.Data.OleDb.OleDbConnectionInternal.GetObjectPool() at System.Data.OleDb.OleDbConnectionInternal..ctor(OleDbConnectionString constr, OleDbConnection connection) at System.Data.OleDb.OleDbConnectionFactory.CreateConnection(DbConnectionOptions options, Object poolGroupProviderInfo, DbConnectionPool pool, DbConnection owningObject) at System.Data.ProviderBase.DbConnectionFactory.CreateNonPooledConnection(DbConnection owningConnection, DbConnectionPoolGroup poolGroup) at System.Data.ProviderBase.DbConnectionFactory.GetConnection(DbConnection owningConnection) at System.Data.ProviderBase.DbConnectionClosed.OpenConnection(DbConnection outerConnection, DbConnectionFactory connectionFactory) at System.Data.OleDb.OleDbConnection.Open() at NopSolutions.NopCommerce.BusinessLogic.ExportImport.ExcelHelper.WriteTable(String tableName, Dictionary`2 tableDefinition) at NopSolutions.NopCommerce.BusinessLogic.ExportImport.ExportManager.ExportProductsToXls(String filePath, List`1 products) at NopSolutions.NopCommerce.Web.Administration.Modules.ProductsControl.btnExportXLS_Click(Object sender, EventArgs e)  
IP address:   xxx.xxx.xxx.xxx
Customer:  xxxxxxxxx  
Page URL:  http://xxxxxxxxxxxxxxxx/administration/products.aspx  
Referrer:  http://xxxxxxxxxxxxxxxx/administration/Products.aspx  
Created on:  10/26/2010 4:37:09 AM