The 'Microsoft.ACE.OLEDB.12.0' provider is not registered on the local machine. in visual studio 2010

Question

hi
i want to load an excel file into datagridview

here is my connection string

string connectionString = String.Format(@"Provider=Microsoft.ACE.OLEDB.12.0;Data Source={0};Extended Properties=""Excel 8.0;HDR=YES;IMEX=1;""", myExcelAddress);

                

i have office  2007 installed on my pc

it run fine on visual studio 2008 whitout any error but when i write this code in my application in 2010 and wpf, it has this error!!!


what can i do?

please suggest me