[AccessD]

Using the Excel export icon on the toolbar limits the output to approx 16k
records, a limitation that goes back (as best as I can remember) to Excel 5.
Use file export and select Excel 2000 to export up to the max of 63k
records. HTH
Jim Hale

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