Dear buddy, I am mad, can you help me and don't drop me as sacrifice

[nenfa]

Hi, When I am trying to import data from excel to table it's giving me following error :- An exception of type 'System.Data.OleDb.OleDbException' occurred in System.Data.dll but was not handled in user code Additional information: External table is not in the expected format. I am using following code:- Collapse OleDbConnection excelConn = new OleDbConnection(); excelConn = new OleDbConnection("Provider=Microsoft.Jet.OLEDB.4.0;Data Source='" + filelocation + "';Extended Properties=Excel 8.0"); excelConn.Open();

[nenfa]

if i open the excel file with excel 2003, then i'll do the query again for the file,everything goes fine, why? how can i get the data from xls, without open it in the excel 2003 at the same time, who can help me ? thanks very much!