HOWTO: Transfer Data from ADO Data Source to Excel with ADO
http://support.microsoft.com/support/kb/articles/Q295/6/46.ASP?LN=EN-US&SD=gn&FR=0&qry=&rnk=3&src=DHCS_MSPSS_gn_SRCH&SPR=VBBHOWTO: Use ADO with Excel Data from Visual Basic or VBA
http://support.microsoft.com/support/kb/articles/Q257/8/19.ASP?LN=EN-US&SD=gn&FR=0&qry=&rnk=3&src=DHCS_MSPSS_gn_SRCH&SPR=VBBHOWTO: Transfer Data from an ADO Recordset to Excel with Automation
http://support.microsoft.com/support/kb/articles/Q246/3/35.ASP?LN=EN-US&SD=gn&FR=0&qry=&rnk=3&src=DHCS_MSPSS_gn_SRCH&SPR=VBB