search

paulyoder / LinqToExcel

Use LINQ to retrieve data from spreadsheets and csv files
MIT License
1.06k stars 299 forks source link

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

Open Kaushik1987 opened 5 years ago

Kaushik1987 commented 5 years ago

I have installed the 64 version of "AccessDatabaseEngine_X64.exe" however for file .xlxs I m getting the error The 'Microsoft.ACE.OLEDB.12.0' provider is not registered on the local machine.

But file .xls is working file for processing.

What could be the possible cause for this ?

mrworkman commented 5 years ago

Your project is probably targeting "any cpu", or "x86".

I'm assuming you're using a 1.x version of LinqToExcel, so that means it uses the Jet database engine when compiled for x86, which is the reason it can read .xls files but not .xlsx files.

Please either change your project to an x64 target, or install the 32-bit version of the ace database engine instead.

uriellramos commented 4 years ago

I Have an issue, Only occur on webserver I have installed ACE.OLEDB.12 .....15 .... and 16 x64 but the error it is the same "The 'Microsoft.ACE.OLEDB.12.0' provider is not registered on the local machine".

I have also tested to change the application target to "Any CPU", "x86" and "x64"