E
ER
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?
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?