pelegk1
03-15-2007, 04:42 AM
i am doing this
Set objConn = Server.CreateObject("ADODB.Connection")
Set objRS = Server.CreateObject("ADODB.Recordset")
objConn.Open "Driver={Microsoft Excel Driver (*.xls)};DriverId=790;Dbq=C:\Inetpub\1\2\3\password_list.xls;DefaultDir=C:\Inetpub\1\2\3;"
strSQL = "SELECT id FROM [sheet1$]"
set rs = objConn.Execute (strSQL)
response.write rs("id")
i want in the query to get a certain line number how do i do that?
something like :
SELECT id FROM [sheet1$] where id=1
thnaks i nadvance
peleg
Set objConn = Server.CreateObject("ADODB.Connection")
Set objRS = Server.CreateObject("ADODB.Recordset")
objConn.Open "Driver={Microsoft Excel Driver (*.xls)};DriverId=790;Dbq=C:\Inetpub\1\2\3\password_list.xls;DefaultDir=C:\Inetpub\1\2\3;"
strSQL = "SELECT id FROM [sheet1$]"
set rs = objConn.Execute (strSQL)
response.write rs("id")
i want in the query to get a certain line number how do i do that?
something like :
SELECT id FROM [sheet1$] where id=1
thnaks i nadvance
peleg