Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.programming
|
|||
|
|||
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? |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
Excel PivotCache Recordset property is it Read/Write? | Excel Programming | |||
Read Excel Spreadsheet Via VB.Net | Excel Programming | |||
ADO recordset closed, cannot read | Excel Programming | |||
how to read excel spreadsheet into database (DB2) | Excel Programming | |||
How to populate a multi-column activeX listbox on a spreadsheet with an ADO recordset | Excel Programming |