A question on read the record from excel
I use the ado to read the record form excel, all is right. But when I read
the phone column, I meet with a serious problem. Some of this fileds is like 999-888888888, I can't read the content. The follow is my program. How can I do? connstr="Driver={Microsoft Excel Driver (*.xls)};dbq=" & server.MapPath("data\test.xls") set conn = server.CreateObject("adodb.connection") set rs=server.CreateObject("adodb.recordset") conn.Open connstr sql = "select * from [Sheet1$]" rs.Open sql,conn While rs.EOF=False Response.Write rs.Fields("UserName") & " " & rs.Fields("Phone") rs.MoveNext Wend rs.Close |
All times are GMT +1. The time now is 09:07 PM. |
Powered by vBulletin® Copyright ©2000 - 2024, Jelsoft Enterprises Ltd.
ExcelBanter.com