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.
Printable View
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.
:DVB Code:
DoCmd.TransferSpreadsheet acImport, acSpreadsheetTypeExcel9, "Table1", "C:\Table1.xls", True