Paul Newton wrote: > Dave > > IIRC the 65536 limit applies to worksheets not workbooks? > > So one should be able to use this method multiple times (with chunks of > 65536 records) and put each chunk in a different worksheet in the same > workbook >
Yes, the limit is for Excel, not ADO, although Excel 2007 has now a limit of 1048576 rows. HTH Saludos, Jaime Vasquez Guatemala C.A. _______________________________________________ Post Messages to: [email protected] Subscription Maintenance: http://leafe.com/mailman/listinfo/profox OT-free version of this list: http://leafe.com/mailman/listinfo/profoxtech Searchable Archive: http://leafe.com/archives/search/profox This message: http://leafe.com/archives/byMID/profox/[EMAIL PROTECTED] ** All postings, unless explicitly stated otherwise, are the opinions of the author, and do not constitute legal or medical advice. This statement is added to the messages for those lawyers who are too stupid to see the obvious.
