The 'Microsoft.ACE.OLEDB.12.0' provider is not registered on the local machine.

Hi All,

I am trying to read excel file and performing some operations. It works fine for local host but causes error when doing on remote server.

I have install access database engine on server and changed connection string as follows

original :-

FileConnectionString = "Provider=Microsoft.Jet.OLEDB.4.0; Data Source=" + FullFilePath + "; Extended Properties=Excel 8.0;";

changed to:-

FileConnectionString = "Provider=Microsoft.ACE.OLEDB.12.0;Data Source=" + FullFilePath + ";Extended Properties=\"Excel12.0HDR=YES;\""; 

but still getting error as

The 'Microsoft.ACE.OLEDB.12.0' provider is not registered on the local machine.

kindly suggest solution asap.

Thanks.