请教:如何实现读取excel特定行特定列的数据呢？

[angel_1180_0]

我原来用的下面这一段:
Set xlApp = server.CreateObject("Excel.Application")

strsource = "c:\excel\Book1.xls"

Set xlbook = xlApp.Workbooks.Open(strsource)
Set xlsheet = xlbook.Worksheets(1)

i=1
response.write "<table cellpadding=0 cellspacing=0 border=1 width=500>"
while xlsheet.cells(i,1)<>""

response.write "<tr>"
response.write " <td height=20 align=center width=100>" & xlsheet.Cells(i, 1) & "</td>"
response.write " <td height=20 align=center width=200>" & xlsheet.Cells(i, 2) & "</td>"
response.write " <td height=20 align=center width=200>" & xlsheet.Cells(i, 3) & "</td>"
response.write "</tr>"
i=i+1

wend
response.write "</table>"
set xlsheet=nothing
set xlbook=nothing
set xlApp=nothing
xlApp.quit
但是运行完一次之后就开一个excel进程，然后就再也不好用了。

[孟子E章]

excelSql = "SELECT * FROM [$sheet1$A1:A2]"
strCnn = "Provider=Microsoft.Jet.OLEDB.4.0;Data Source=" & strFilePath & ";Extended Properties=Excel 8.0;"

Set excelCn = Server.CreateObject("ADODB.Connection")
excelCn.Open strCnn
Set rs = excelCn.execute(excelSql)

[angel_1180_0]

那比如说：要显示一下excel表“入库表”的第a3个元素
怎么表示阿？我想把该元素表示出来，然后经过判断放入sql数据库中/

[lovedogdog]

mark