i just want to ask about Visual studio doesn't detect my microsoft.ace.oledb.12.0..

last month i write a code to import from excel into database using VB.NET and it worked.. but after a month i open back my coding and try the system but it said that "microsoft.ace.oledb.12.0 provider is not registered" even though i already install microsoft access database engine 2010 before..

i never change a little bit of my coding..i just left it but now it doesn't work like before

is there any particular update or something that make it doesn't work??

thank you

CodePudding user response：

Try changing your target cpu in your project properties. go to solution explorer<properties<Compile uncheck the prefer 32-bit or change to x64. It works for me, if it doesn`t work try searching a bit more iirc that question is already answered but i cant remember if it is in stackoverflow or other website, which has many suggestions