Ok,
Well since you provided no information about what columns are in your table (excel spreadsheet) and what data you want from that table (i.e. DDL (Data Definition Language)) providing help on a query will be rather hard.
So until you provide that information, help will be difficult to get.
The provider
"Microsoft.Jet.OLEDB.4.0" is for Access not Excel, so your first choice was correct.
Provide the query you have tried!
Do you know how to creat a recordset?
Example:
Table (excel spreadsheet)
Col A || Col B
Dim objConn
Set objConn = Server.CreateObject ("ADODB.Connection")
objConn.Open "Driver={Microsoft Excel Driver (*.xls)};DriverId=790;DBQ=" & Server.mappath("/"& excelfilename) &";ReadOnly= false ; UID=admin;"
Dim strSQL
strSQL = "SELECT Col A FROM excelfilename"
Dim objRS
Set objRS = Server.CreateObject ("ADODB.RecordSet")
objRS.Open strSQL, objConn
...
...
' Your code to display this recordset
...
...
' Memroy/garbage clean up.... in the proper order
objRS.Close
Set objRS = Nothing
objConn.Close
Set objClose = Nothing
... Hope this helps, but please provide further information if you want more detailed help!
Hello
I am new in ASP
what i want is to retrive the records from excel sheet and show them on an asp page in tabular format
i tried to do it with ADODB.Connection
conn.Provider = "MSDASQL"
conn.ConnectionString = "Driver={Microsoft Excel Driver (*.xls)};DriverId=790;DBQ=" & Server.mappath("/"& excelfilename) &";ReadOnly= false ; UID=admin;"
the connection get opened successfully but no the main problem is to fetch the data into recorset. the error comes into query
pls do tell me what should b the query for fetching the record
i also tried the "Microsoft.Jet.OLEDB.4.0" provider but it gives an error in connection as "cant find installable isam"
thanks
Offline 
Unsolved 
