asp excel

[magix]

I try to use asp to extract excel data. if the item field in excel is empty,
can I use "" to represent empty ?

will this (" ") work ?
rs("Item") = ""

rs.open "SELECT * FROM [Sheet1$]", oConn
do until rs.EOF
if rs("Item") = "" then
emptyfield = true
else
emptyfield = FALSE
end if
rs.movenext
Loop

[ThatsIT.net.au]

Without making a connection and testing it, I would think yes.

if not try Trim(rs("Item")) = ""
or even Trim(Cstr(rs("Item"))) = ""

or maybe rs("Item") = null

--
Dim Alan as ThatsIT.net.au.Staffmember
Alan.signature = "Thank You"
Response.Write Alan.signature.toString()
__________________________________________

"magix" <ma***@asia.comwrote in message
news:46**********@news.tm.net.my...

>I try to use asp to extract excel data. if the item field in excel is
empty, can I use "" to represent empty ?

will this (" ") work ?
rs("Item") = ""

rs.open "SELECT * FROM [Sheet1$]", oConn
do until rs.EOF
if rs("Item") = "" then
emptyfield = true
else
emptyfield = FALSE
end if
rs.movenext
Loop