Monday, December 21, 2009

Too much data to export to Excel ...

Q: Is there a way to export our gun log to excel? ATF will accept an electronic copy instead of a printed copy. We are required to print one every year..

A: The gunlog has an “Export to Excel” button at the bottom left.

Q: When I try to export we get this error ....
Error No: 2306
Error Description: There are too many rows to output, Based on limitation specified by the output format or by Dazzle Pawn
Line No: 1450
Procedure: CMDEXPORT_CLICK
VBA Document FORM_FRMEDITGUNLOG

A: If your gunlog is very big you might have to do it in 2 sections. Maybe more.
Set a filter for everything through (say) year 2000, and export.
Then repeat for 2001-2009.


Q: Thanx, looks like that will work...