Access Pro
accesspro at cox.net
Thu Apr 3 12:27:14 CDT 2014
Ok it's going to be a remote in to his Off 2007. An aside: I experimented with using .txt .cvs and other file formats when first creating this project. I got some wildly differing results for numbers and formatting when getting into Excel. I even noticed a difference in how Access outputs from the menu (Tools, Office Links, Analyze it with Excel) and the TransferSpreadsheet function. So thanks again. Bob Heygood Still not giving up on A2003 -----Original Message----- From: accessd-bounces at databaseadvisors.com [mailto:accessd-bounces at databaseadvisors.com] On Behalf Of Access Pro Sent: Wednesday, April 02, 2014 6:09 PM To: 'Access Developers discussion and problem solving' Subject: Re: [AccessD] Access to Excel 65K row barrier 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