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

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