read excel

[ash]

i use the following code to read excel
Set ExcelConn = Server.CreateObject("ADODB.Connection")
Set ExcelRS = Server.CreateObject("ADODB.Recordset")
......
sSQL = "SELECT * FROM [Sheet1$]"
set ExcelRS = ExcelConn.Execute(sSQL)

it work fine for those cell that contained string , but once the cell is numeric, i cant get anything in the cell. How can i solve this problem.

many thx

[Ray Costanzo [MVP]]

Try adding "IMEX=1;" to your connection string. If you're not sure how or
where, post your connection string and I'll modify it for you.

Ray at work

"ash" <as*@gmail.comwrote in message
news:%2****************@TK2MSFTNGP03.phx.gbl...
i use the following code to read excel
Set ExcelConn = Server.CreateObject("ADODB.Connection")
Set ExcelRS = Server.CreateObject("ADODB.Recordset")
......
sSQL = "SELECT * FROM [Sheet1$]"
set ExcelRS = ExcelConn.Execute(sSQL)

it work fine for those cell that contained string , but once the cell is
numeric, i cant get anything in the cell. How can i solve this problem.

many thx