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

[byka]

I am running batch apps on Windows 2012 server and getting the following error: MESSAGE: The 'Microsoft.ACE.OLEDB.12.0' provider is not registered on the local machine My connection string: Provider=Microsoft.ACE.OLEDB.12.0;Data Source=C:\Temp\File.xls; Extended Properties="Excel 12.0 Xml;HDR=YES"; Excel 2010 installed on a server what am I missing?

[Lost User]

As stated in the message you are missing the ACE driver. Check Microsoft.ACE.OLEDB - Google Search[^] to see which one applies to your situation.

[byka]

On a server I have Excel 10 installed. what do I need to change in my connection in order to use it?

[Lost User]

Never heard of Excel 10.

[byka]

Microsoft Office Professional Plus 2010

[Lost User]

Then you need to install the ACE driver as suggested earlier.

[Triche Astuce]

you need install ACE?