[AccessD]

DWUTKA at marlow.com DWUTKA at marlow.com
Thu Jan 15 13:38:49 CST 2004


That is a limitation of excel.  It can only handle 16k 'records'.

Drew

-----Original Message-----
From: Stoker, Kenneth E [mailto:Kenneth.Stoker at pnl.gov]
Sent: Thursday, January 15, 2004 11:29 AM
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


More information about the AccessD mailing list