ADO recordset

How do I create an ADO recordset from an excel spreadsheet?

I have a table of date in an excel spreadsheet that I need to append to an Access table.

Help please.

Thats the hard way. Do it from Access in one line of code.

VB Code:

DoCmd.TransferSpreadsheet acImport, acSpreadsheetTypeExcel9, "Table1", "C:\Table1.xls", True

:D