Hi All,

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.

Any help would be appreciated...