View Single Post
  #1   Report Post  
Posted to microsoft.public.excel.programming
er er is offline
external usenet poster
 
Posts: 5
Default Read of excel spreadsheet with ADO recordset

With VBA, am reading an external Excel spreadsheet using ADODB. This has
been working great, but now the external spreadsheet has more than 3000 rows
and I am getting error:

[Microsoft][ODBC Excel Driver] This table contains cells that are outside
the range of cells defined in this spreadsheet.

If I cut back the #rows, it works fine. Even though I know Excel isn't
the best choice for a database here, it's what I'm dealing with. And I did
not anticipate hitting a limit this early.

Anyone know a work-around?