ADO Connection.Execute保持返回已关闭的记录集

I'm trying to return the results of a sql command, passed to SQL server, into Excel using ADO objects, but my Recordset keeps coming back closed/empty. My guess is that my sql statment is not return anything - though I think it SHOULD be returning a single record.I'm trying to return the results of a sql comma