is there something built in to adomd that checks if a query returns nothing?
similar to:- if rs.recordcount = 0 then ...
and if it has values, then drop into excel quickly like:- cells(1,1).copyfromrecordset()
thanks
empty cellset
empty cellset
Yeon