[AccessD]

I assume that s/he is using TransferSpreadsheet to export to Excel as in...

docmd.TransferSpreadsheet acExport ,etc. etc.

The second parameter (the one after acExport) defaults to
acSpreadsheetTypeExcel3 which cannot handle the 17k rows. If you choose
acSpreadsheetTypeExcel97 or higher for this parameter it should work fine.

Lambert

> -----Original Message-----
> From:	Stoker, Kenneth E [SMTP:Kenneth.Stoker at pnl.gov]
> 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