28,391
社区成员
发帖
与我相关
我的任务
分享100分，关于Excel的一个操作，急急急急急急急急急。。。。。
excel表里明明有数据,但读出来是空值.
什么原因的，我找了N天了。
谢谢！
什么原因的，我找了N天了。
谢谢！
...全文
请发表友善的回复…
发表回复
liefeng123 2004-07-23
- 打赏
- 举报
strDriver = "Driver={Microsoft Excel Driver (*.xls)};DBQ=C:\Inetpub\Wwwroot\Tutorial\MyExcel.xls;"
Set objConn = Server.CreateObject("ADODB.Connection")
objConn.Open strDriver
'Selects the records from the Excel spreadsheet using the workbook name you saved.
strSELECT = "SELECT * from `MYBOOK`"
'Create an instance of the ADO Recordset object, and connect it to objConn.
Set objRS = Server.CreateObject("ADODB.Recordset")
objRS.Open strSELECT, objConn
Set objConn = Server.CreateObject("ADODB.Connection")
objConn.Open strDriver
'Selects the records from the Excel spreadsheet using the workbook name you saved.
strSELECT = "SELECT * from `MYBOOK`"
'Create an instance of the ADO Recordset object, and connect it to objConn.
Set objRS = Server.CreateObject("ADODB.Recordset")
objRS.Open strSELECT, objConn
bananasmiling 2004-07-23
- 打赏
- 举报
1.你读取的条件不对..
2.你的EXCEL有问题..
2.你的EXCEL有问题..
孟子E章 2004-07-23
- 打赏
- 举报
http://msdn.microsoft.com/library/default.asp?url=/library/en-us/iissdk/iis/displayinganexcelspreadsheet.asp
oldjackyone 2004-07-23
- 打赏
- 举报
我自己行顶。。。。。
