Query of an SQL Database

B

brewabel

Joined
Jun 2, 2005
Messages
2
Reaction score
0
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.
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Similar Threads

Excel Query setup 0
Microsoft Query is changing a negative number into a date 1
Excel Limitations & Possible Add-Ins 1
Excel with SQL Query (*.sql) and SQL Server 2
expand number of rows from limit of 65,536? 2
limit records in query 2
Database Query Missing 4
Combine Duplicates in Query 0

Back
Top