Unable to open oledb connection

Ganesh Murthy

Jul 28 2005 4:14 PM

1.9k

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