(dhl)Using 2K. I have a query I want to export to excel. There are
35,000+ lines for this query. I created a macro to run on a schedule
to export the excel file to a network shared drive. I can manual
export the query to excel, but when I run the macro, access said
"There are too many rows to output, based on limitation specified by
the output Format". In the macro I am using the "Output To" "Query"
to "Excel". I do not see where I put row limitatoins. Thank you for
your help. David
35,000+ lines for this query. I created a macro to run on a schedule
to export the excel file to a network shared drive. I can manual
export the query to excel, but when I run the macro, access said
"There are too many rows to output, based on limitation specified by
the output Format". In the macro I am using the "Output To" "Query"
to "Excel". I do not see where I put row limitatoins. Thank you for
your help. David
Comment