Hi every body.
Please help me, I have some problem when I connect to an excel file(using ADO) to collect information. But my problem is : I can't get data correctly. If one column in my excel file contain more than two kinds of data, example : one column contains text and datetime . Then I can't get data correctly, one of them return Null Value.
Here is my coding:
-------------------------
set objConn = server.CreateObject("ADODB.Connection")
strConnect = "DRIVER={Microsoft Excel Driver (*.xls)};Extended Properties=Excel 8.0;HDR=No; DBQ=" & ExcelFileName
objConn.Open strConnect
--------------------------------
//the operation to open a recordset to get sheet1's data
set rs = server.CreateObject("ADODB.Recordset")
rs.open "select * from [sheet1$]",objconn,1,1
-------------------------------------
with :
ExcelFileName : parameter
[/b]

StevenThu