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

If this query got resolved then please Accept the post that helped you as Answer.
So other members can easily find the answers.

the forum link posted didnt helped you?
same code not working on your system?

Hello All,

 When i try to read data from .xlsx, that time its given me the following error.

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

i have used following connection string and also Provider=Microsoft.ACE.OLEDB.12.0 has been installed on server.


if (strFileType.Trim() == ".xls")
            {
                connString = "Provider=Microsoft.Jet.OLEDB.4.0;Data Source=" + strNewPath + ";Extended Properties=\"Excel 8.0;HDR=Yes;IMEX=2\"";
            }
            else if (strFileType.Trim() == ".xlsx")
            {
               connString = "Provider=Microsoft.ACE.OLEDB.12.0;Data Source=" + strNewPath + ";Extended Properties=\"Excel 12.0;HDR=Yes;IMEX=2\"";  
              
            }


is there need to add references?

If Yes then may i need to add which  references?

If No then how can i resolve it?

If any one know solution of this issue so please help me .


Thnaks ,
vijay

I assume that the problem is due to your application executing in a 64-bit version of Windows and that system does not have a 64-bit version of OLEDB. If so the Suthish's suggestion should work.
Years ago, Microsoft decided they wanted to discontinue support of some databases such as Access. I forget if that includes OLEDB for Excel but I think so. So they did not create 64-bit versions and we had to use 32-bit applications for the databases. The amount of protest from customers was great enough that Microsoft gave in (like as Hosni Mubarak has done?) and they have provided 64-bit versions. So you have two choices; either look for a 64-bit version of OLEDB or (as Suthish suggests) make your application 32-bit.

refer msdn forum
try, changing the advanced compile configuration to x86 found in the programs properties if your running 64 bit system.