John W Colby
jwcolby at gmail.com
Wed Apr 2 17:49:57 CDT 2014
I have always wondered about performance with these huge spreadsheets. John W. Colby Reality is what refuses to go away when you do not believe in it On 4/2/2014 6:47 PM, Darryl Collins wrote: > Double?? > > Try 65,545 Rows (2003) vs 1,048,576 Rows (2007+) > > Much more than double! > > Cheers > Darryl. > > -----Original Message----- > From: accessd-bounces at databaseadvisors.com [mailto:accessd-bounces at databaseadvisors.com] On Behalf Of John Serrano > Sent: Thursday, 3 April 2014 7:24 AM > To: Access Developers discussion and problem solving > Subject: Re: [AccessD] Access to Excel 65K row barrier > > Bob, > > The newer version of Excel has double the row size however as time goes on will this suffice? > I guess the real question is why are you taking data from a query into excel? Do you need to perform additional analysis on the data or just report it out? > > Nevertheless, you could change your references in your library to Office > 14.0 I beleive it is... > > > On Wed, Apr 2, 2014 at 4:12 PM, Bob Heygood <accesspro at gmail.com> wrote: > >> Hello to the list, >> >> I have been using the Access 2003 to export the results of a query to >> Excel. >> All has been well until the query has grown to over 65K rows/records. >> My client has Off 2010. >> >> I just don't want to upgrade to a newer version of Office. >> I have Google docs and SkyDrive office. >> >> So, the question is how to get him an Excel file in Off 2007 or 2010 >> format ? >> I can't create too much work on his end. He so far is not able to >> splice two files together. >> >> >> TIA >> >> Bob Heygood >> >> -- >> AccessD mailing list >> AccessD at databaseadvisors.com >> http://databaseadvisors.com/mailman/listinfo/accessd >> Website: http://www.databaseadvisors.com >> > > > -- > John Serrano > -- > AccessD mailing list > AccessD at databaseadvisors.com > http://databaseadvisors.com/mailman/listinfo/accessd > Website: http://www.databaseadvisors.com > --- This email is free from viruses and malware because avast! Antivirus protection is active. http://www.avast.com