By using this site, you agree to our updated Privacy Policy and our Terms of Use. Manage your Cookies Settings.
459,747 Members | 1,349 Online
Bytes IT Community
+ Ask a Question
Need help? Post your question and get tips & solutions from a community of 459,747 IT Pros & Developers. It's quick & easy.

Output Excel File (dhl)

P: n/a
(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
Nov 13 '05 #1
Share this Question
Share on Google+
1 Reply

P: n/a
Use TransferSpreadsheet instead of OutputTo.
Nov 13 '05 #2

This discussion thread is closed

Replies have been disabled for this discussion.