[AccessD] Access to Excel 65K row barrier

You can put the macros in your excel 2003 worksheet that the client calls
from a button click to pump the data to a new excel (xlsx) file and close
itself. Very simply.
On Apr 2, 2014 9:09 PM, "Access Pro" <accesspro at cox.net> wrote:

> Thanks to all who responded.
>
> It has to be Excel.
> It has to be 10K+ rows/records.
> I know that the newer versions of Excel do this.
> It is an ongoing data conversion project. So this has to be repeated over
> 50
> times, over weeks.
>
> I thought that someone might have had experience using another program that
> will output Excel 2007+ files.
>
>
> I will probably be dragged kicking to install 2013 here, or convince the
> client that I have to remote in.
>
> Bob
>
>
> -----Original Message-----
> From: accessd-bounces at databaseadvisors.com
> [mailto:accessd-bounces at databaseadvisors.com] On Behalf Of Stuart
> McLachlan
> Sent: Wednesday, April 02, 2014 2:02 PM
> To: Access Developers discussion and problem solving
> Subject: Re: [AccessD] Access to Excel 65K row barrier
>
> How about exporting to a Tab delimited text file instead.  Excel will read
> it just fine.
>
> On 2 Apr 2014 at 13:12, Bob Heygood 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
> >
>
>
> --
> 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
>