[AccessD] Access to Excel 65K row barrier

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