[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
>