I have a query made to pull information in from a SQL database. From
time to time, this query exceeds the the 65,000 row limitation. So the
question is kind of two part.

1. How can I limit the query to only pull 65,536 rows of data?

2. How can I force the query to start dumping to a new worksheet once
the first one has reached it's capacity?

Thanks.


--
brewabelPosted from http://www.pcreview.co.uk/ newsgroup access