[AccessD] Access to Excel 65K row barrier

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



More information about the AccessD mailing list