| Home |
| Search |
| Today's Posts |
|
#1
|
|||
|
|||
Query of an SQL Database
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 |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| Database Query -- Data Type Mismatch | Excel Discussion (Misc queries) | |||
| HELP! Lose Database Query upon Refresh | Excel Worksheet Functions | |||
| Excel Database Query String Too Long | Excel Discussion (Misc queries) | |||
| Query a Access database that has a module from Excel | Excel Discussion (Misc queries) | |||
| How to use a Access Query that as a parameter into Excel database query | Excel Discussion (Misc queries) | |||
Threaded Mode
