T
TheScullster
Hi all
We have an Access2000 application which controls drawing status etc.
One of the features of this app is to output drawings to an Excel table.
Today it seems that we have exceeded some limit in number of records.
When trying to generate an Excel output from a particular search we obtain
the error:
Run Time Error 2306
There are too many rows to output, based on the limitations specified by the
output format or by "Data Manager" (the filename).
The debug window leads to the following code:
DoCmd.OutputTo acOutputTable, "exceltemp", acFormatXLS, "c:\temp.xls", True
Anyone know the reason for this please?
The search states that there are 21800 records returned by this search.
TIA
Phil
We have an Access2000 application which controls drawing status etc.
One of the features of this app is to output drawings to an Excel table.
Today it seems that we have exceeded some limit in number of records.
When trying to generate an Excel output from a particular search we obtain
the error:
Run Time Error 2306
There are too many rows to output, based on the limitations specified by the
output format or by "Data Manager" (the filename).
The debug window leads to the following code:
DoCmd.OutputTo acOutputTable, "exceltemp", acFormatXLS, "c:\temp.xls", True
Anyone know the reason for this please?
The search states that there are 21800 records returned by this search.
TIA
Phil