Darryl Collins
darryl at whittleconsulting.com.au
Wed Apr 2 17:57:23 CDT 2014
That is a good point John. In many instances the PC will choke way before you get anywhere near the limits of the available ranges. Performance can be an issue with XL2007+. If it is well designed you can avoid most of these pitsfall, but in reality all it has done for many places is create a much bigger and uglier mess. These things are usually filled with little errors and bugs that are loathsome and difficult to track down. The sheer size and flexibility of XL is both its power and failing. Cheers Darryl. -----Original Message----- From: accessd-bounces at databaseadvisors.com [mailto:accessd-bounces at databaseadvisors.com] On Behalf Of John W Colby Sent: Thursday, 3 April 2014 9:50 AM To: Access Developers discussion and problem solving Subject: Re: [AccessD] Access to Excel 65K row barrier 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 -- AccessD mailing list AccessD at databaseadvisors.com http://databaseadvisors.com/mailman/listinfo/accessd Website: http://www.databaseadvisors.com