[AccessD] Access to Excel 65K row barrier

Darryl Collins darryl at whittleconsulting.com.au
Wed Apr 2 18:09:31 CDT 2014


Yes, I think you are correct.  Even today some process will limit you to 65K rows.  Legacy stuff that lurks deep in the machine...

Heh... took me a while to 'get' the baseball reference, but now I understand :)



-----Original Message-----
From: accessd-bounces at databaseadvisors.com [mailto:accessd-bounces at databaseadvisors.com] On Behalf Of Bill Benson
Sent: Thursday, 3 April 2014 10:03 AM
To: Access Developers discussion and problem solving
Subject: Re: [AccessD] Access to Excel 65K row barrier

Are you sure that he is referring to the catcher and not the pitcher?

I didn't contradict for once just in case this was a limitation of Access rather than Excel, though my thinking lacks much logic.
On Apr 2, 2014 6:48 PM, "Darryl Collins" <darryl at whittleconsulting.com.au>
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
>
> --
> AccessD mailing list
> AccessD at databaseadvisors.com
> http://databaseadvisors.com/mailman/listinfo/accessd
> Website: http://www.databaseadvisors.com
>
--
AccessD mailing list
AccessD at databaseadvisors.com
http://databaseadvisors.com/mailman/listinfo/accessd
Website: http://www.databaseadvisors.com



More information about the AccessD mailing list