[AccessD] Access to Excel 65K row barrier

Gary Kjos garykjos at gmail.com
Wed Apr 2 16:07:20 CDT 2014


If you are not doing special formatting ext in excel you can create a .csv
text file and Excel will open that just fine.


On Wed, Apr 2, 2014 at 3: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
>



-- 
Gary Kjos
garykjos at gmail.com


More information about the AccessD mailing list