A question on read the record from excel

W

weizi

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
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Top