John W. Colby
jwcolby at colbyconsulting.com
Thu Jan 15 11:49:57 CST 2004
Back it off to 16K and try again. It may be a limitation in Excel. John W. Colby www.ColbyConsulting.com -----Original Message----- From: accessd-bounces at databaseadvisors.com [mailto:accessd-bounces at databaseadvisors.com]On Behalf Of Stoker, Kenneth E Sent: Thursday, January 15, 2004 12:29 PM To: AccessD at databaseadvisors.com Subject: [AccessD] I have a coworker who is getting the following error message when trying to output 17K+ records from a query to Excel. There are too many rows to output, based on the limitation specified by the output format or by Microsoft Access. Is there a setting that can be changed to increase the amount output? Is she hitting a limitation? Can anyone help here. Thanks. Ken Stoker Technology Commercialization Information Systems Administrator PH: (509) 375-3758 FAX: (509) 375-6731 E-mail: Kenneth.Stoker at pnl.gov _______________________________________________ AccessD mailing list AccessD at databaseadvisors.com http://databaseadvisors.com/mailman/listinfo/accessd Website: http://www.databaseadvisors.com