Reading Excel file using Microsoft OLEDB problem!

[exampass2004]

Dear all, Good day to all of you. Can someone help me for some microsoft oledb problem. Actually, I received this message when I request a search result from my asp file. Microsoft OLE DB Provider for ODBC Drivers error '80040e21' ODBC driver does not support the requested properties. /result_new.asp, line 210 Hope to see reply as soon as possible, thanks you. Below is some of my coding in result new.asp file Set cnnExcel = Server.CreateObject("ADODB.Connection") cnnExcel.Open "DBQ=" & Server.MapPath("STOCK.xls") & ";" & _ "DRIVER={Microsoft Excel Driver (*.xls)};" Set rstExcel = Server.CreateObject("ADODB.Recordset") rstExcel.Open "Select * from Stocks", cnnExcel 'Error messages result_new/asp, line 210 is this line (rstExcel.Open "Select * from Stocks", cnnExcel), can someone please try to have a look into it, thanks you.

[Jerome]

Before you try to query your excel file, you should first simply try to display all the data of your excel file into your asp page. Follow this tutorial (http://support.microsoft.com/kb/q195951/)If it works, pls let us know!