Stoker, Kenneth E
Kenneth.Stoker at pnl.gov
Thu Jan 15 13:38:45 CST 2004
Actually, no, she is not a programmer, just trying to create her own queries and then export them to Excel using Tools --> Office Links --> Analyze in Microsoft Excel. Using this option worked at 16K records (showed her how to use the TOP keyword for this), but failed on 17K+ records. That wasn't acceptable, so we tried to just copy the results from the query into the clipboard and then paste the clipboard contents into the Excel spreadsheet. Surprise, we got almost 31K records into the spreadsheet with this approach, which is what her query returned when all the criteria was removed. She said that she will try to remember if it is over 16K records, to follow the last option above. Ken Stoker Technology Commercialization Information Systems Administrator PH: (509) 375-3758 FAX: (509) 375-6731 E-mail: Kenneth.Stoker at pnl.gov -----Original Message----- From: Heenan, Lambert [mailto:Lambert.Heenan at AIG.com] Sent: Thursday, January 15, 2004 9:50 AM To: 'Access Developers discussion and problem solving' Subject: RE: [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 _______________________________________________ AccessD mailing list AccessD at databaseadvisors.com http://databaseadvisors.com/mailman/listinfo/accessd Website: http://www.databaseadvisors.com