Hi
i'm trying to export a query but am getting the following error :
You selected more records than can be copied onto the Clipboard at one time. Divide the records into two or more groups, and then copy and paste one group at a time. The maximum number of records you can paste at one time is approximately 65,000
the sql is built dynamically based on list box selections from users and can be upto 5 years data (approx 430k records). I then create a temporary qryDef and use OutputTo to put it out to excel.
Is there something i can do to overide the limit or a different way of outputting my sql?
Thanks
i'm trying to export a query but am getting the following error :
You selected more records than can be copied onto the Clipboard at one time. Divide the records into two or more groups, and then copy and paste one group at a time. The maximum number of records you can paste at one time is approximately 65,000
the sql is built dynamically based on list box selections from users and can be upto 5 years data (approx 430k records). I then create a temporary qryDef and use OutputTo to put it out to excel.
Code:
' create a temp query def
Set qdfNew = CurrentDb.CreateQueryDef("qd_tmpQry", sqlStatement)
' output qry to excel
DoCmd.OutputTo acOutputQuery, "qd_tmpQry", acFormatXLSX, "", True
Is there something i can do to overide the limit or a different way of outputting my sql?
Thanks