[AccessD] Access to Excel 65K row barrier

Stuart McLachlan stuart.mclachlan at gmail.com
Wed Apr 2 17:12:20 CDT 2014


Please, Tab not Comma.  There is no standard for CSV files wrtnumbers v text, quoting etc 
and it can get screwed up too easily.

-- 
Stuart

On 2 Apr 2014 at 16:07, Gary Kjos wrote:

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