Unanswered: ADO: Append Excel data into Access 2k2 table
I've search the forum, web, msdn and haven't come up with any solutions. Here's how I'm setup: I want to import data from an excel worksheet into an access table without using the 'TransferSpreadsheet' command.
The ws contains about 35000 rows and TransferSpreadsheet takes more than a minute to get all the data. So I decided to see if there was a way of doing it with ADO.
While I know how to connect to an Excel file with ado and create a recordset and then traverse that recordset and add a new row to the other open recordset with my access table as a source; but there has to be another way?
SQL server has the OPENROWSET sql function, however Access doesn't like. it.