为什么这样提取excel表里的数据时,无法提取字符,只能取出数字?????
Dim conn
Dim excelPath,connExcelStr
Dim rs
Set conn=Server.CreateObject("ADODB.Connection")
excelPath = server.MapPath("../excls/test.xls")
connExcelStr="Provider=Microsoft.Jet.OLEDB.4.0;Data Source=" & excelPath & ";Extended Properties=Excel 8.0"
conn.open connExcelStr
Set rs = Server.CreateObject("ADODB.Recordset")
<%
do while not rs.eof
%>
<tr align="center" bgcolor="#66CC66">
<td height="20"><%=rs("name")%></td>
<td height="20"><%=rs("sex")%></td>
<td height="20"><%=rs("age")%></td>
</tr>
<%
rs.movenext
loop
%>
</table>
如果值里有字符,就无法显示。。为什么???