MS 's access of reading the OLEDB support to the database data in EXCEL ,
Lacoste Arin Patent Trainers, so you tin accessible way file from excel , yet 1 object to note , to read file from excel , you can no perform the access to use reading,
Lacoste Radiate Croc Trainers, but must Open the way to use to peruse
routine :
obscure ConnExcel, sql,
Lacoste Trainers UK, R######cel, ExcelFile
ExcelFile =
ConnExcel = ConnectToExcel (ExcelFile) ' Note that the chart appoint must be the following side this format test
Sql =
Set R######cel = Server.CreateObject (
'ASP reading excel data,
Lacoste Observe Strap Trainers, use the open method , which can not execute method to be wrong with the execute
R######cel.open Sql, ConnExcel, 1,
Womens Lacoste Trainers,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,
Womens Lacoste Arin Trainers, ConnStr, Rs
' build Connection thing
Set ConnName = Server.CreateObject (
'ConnStr =
'ConnStr =
ConnStr =
' phone the Open usage apt open the database
ConnName.Provider =
ConnName.ConnectionString = ConnStr
ConnName.Open
set ConnectToExcel = ConnName
Set ConnName = nothing
End Function