Hi,
Iam trying to read a Excel file from C# using oledb connection
Here is my code:
string strConnectionString = @"Provider=Microsoft.Jet.OLEDB.4.0;Data Source=C:\MyExcle.xls;Extended Properties=""Excel 8.0;HDR=Yes;""" ;
OleDbConnection objConn =
new OleDbConnection (strConnectionString);
objConn.Open();
Iam getting an "Unspecified error" whenever I try to open the connection. I have checked
the connection string and its perfectly alright. I have added the aspnet account to the folder
and there shouldnt be any problem with IIS permissions.
I have tried a lot but unable to open the connection.
Can anyone please help me fast ? thanks in advance
Regards
Ganesh