Perfect. I was able to use the ADO.Recordset I was already passing in to
CopyFromRecordset as the Connection parameter. My code automates Excel from
within Access. I did have problems intially with Run-time error '462': The
remote server machine does not exist or is unavailable. It's explained as
part of KB 178510. Explicitly using the Excel object I previously
instatiated to get at ActiveSheet and the Destination range solved it.

"XL" is the Excel Application Object. "TheData" is the ADO.Recordset.

With XL.Worksheets(1).QueryTables.Add( _
Connection:=TheData, _
Destination:=XL.Worksheets(1).Range("A2"))
End With

Thanks for your guidance on this one.
x.