| Home |
| Search |
| Today's Posts |
|
|
|
#1
Posted to microsoft.public.excel.programming
|
|||
|
|||
Excel 2007 - ADO - More than 65536 rows - Problem ?
Check the data for:
1. Single quotes 2. Linefeeds 3. Unusually long strings To be on the safe side, copy the first 50K rows into the WorkSheet a bunch of times to confirm that the problem *really* has to do with the number of rows. If all else fails - move the data out of Excel and into a database. Organize the data like a normal person. |
| Reply |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| Excel 2007 - ADO - More than 65536 rows - Problem ? | Excel Programming | |||
| How do I get my Excel 2007 worksheet to go beyond 65536 rows? | Excel Worksheet Functions | |||
| xlsx 2007 display only 65536 rows | Excel Discussion (Misc queries) | |||
| Why Excel 2007 still have the 65536 raw limit? | Excel Discussion (Misc queries) | |||
| Excel 2007 65536 rows-convert | Excel Discussion (Misc queries) | |||
![gimme_this_gimme_that@yahoo.com[_2_] is offline](https://www.excelbanter.com/images/SultanThemeVB3R/statusicon/user_offline.gif)
Hybrid Mode
