MS's way of reading the OLEDB support to the database data in EXCEL, so you can easily access data from excel, but one thing to note, to read data from excel,air max 2010, you can not execute the way to use reading, but must open the way to use to read
routine:
dim ConnExcel,nike air max shoes, sql, R######cel, ExcelFile
ExcelFile = \
ConnExcel = ConnectToExcel (ExcelFile) 'Note that the table name must be the following side this format test \
Sql = \
Set R######cel = Server.CreateObject (\
'ASP reading excel data,nike air max sale, use the open method, which can not execute method to be wrong with the execute
R######cel.open Sql,air max 2009 sale, ConnExcel, 1,nike air max cheap,3
IF R######cel.Eof And R######cel.Bof Then
Response.write \
Else
Do While Not R######cel.EOF
Response.write R######cel (0)
R######cel.MoveNext
Loop
End IF
R######cel.Close
Set R######cel = nothing
Function ConnectToExcel (FileName)
Dim ConnName, ConnStr,nike air max 2010, Rs
'create Connection object
Set ConnName = Server.CreateObject (\
'ConnStr = \
' ConnStr = \
ConnStr = \
'call the Open method to open the database
ConnName.Provider = \
ConnName.ConnectionString = ConnStr
ConnName.Open
set ConnectToExcel = ConnName
Set ConnName = nothing
End Function