I see a couple of options off top of my head:

- Loop through a recordset of the data and write line items to the Excel Application New Workbook Object.

- Use...

Also check your MDAC Version on the SQL Server machine.  We had out brilliant IT Team push out new security patches that include MDAC Changes.  Well - All linked servers...