The number of rows in a single worksheet has changed from version to version in Excel. If you use COPY TO then you have to check how many rows will be copied and split the data accordingly. Use automation and you still have to check the version of Excel to determine what the max number of rows can be created.
rk -----Original Message----- From: [email protected] [mailto:[email protected]] On Behalf Of Stephen Russell Sent: Wednesday, September 01, 2010 1:24 PM To: [email protected] Subject: Re: Foxpro 2.5 has a row limit when exporting to Excel On Wed, Sep 1, 2010 at 11:52 AM, Michael Madigan <[email protected]> wrote: > Technically an early Excel limit > > I tried to export 19000+ records to Excel from foxpro 2.5 and it stopped at > 16,383 ---------------- Isn't that an excel function? Or another reason not to upgrade your Office because who would need all those rows anyway. Just bloatware right? _______________________________________________ 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/df1eef11e586a64fb54a97f22a8bd0441900496...@ackbwddqh1.artfact.local ** 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.
