i have make excel import utility.
it is working perfectly in 32 bit system.
But it is not working in 64 bit system.
it gives below error...
microsoft.jet.oledb.4.0' provider is not registered on the local machine.
i have use below connection string for excel.
for that i have change project-> property-> buld-> target framwork -> x86
But using this, project will generate exe for 32 bit system. so its not work for 64 bit system..
if i change target framwork to x64, then also it is not working..
please give me solution for that...
What I have tried:
ExcelConnStr = "Provider=Microsoft.Jet.OLEDB.4.0;Data Source=" + pFileName + ";Extended Properties=\"Excel 8.0;HDR=Yes;IMEX=1\";";
OleDbConnection objConn = new OleDbConnection(ExcelConnStr);