I am accessing an Excel sheet via ADO. No problems there.

What I am doing now is taking the sheet data and inserting it into an SQL Table and I'm having a problem with NULL

Invalid Use Of NULL

Code:
Dim clid as Integer
clid = IIf(IsNull(rstExcel.Fields("clientid")), 9999, CInt(rstExcel.Fields("clientid")))
I would think that if I am evaluating NULL then If NULL giving a value, else Converting it to INT I would get what I want. Debug shows ClientID as NULL.