ST Alpha - "Dump the results into a table with an ID field, then pull the top 65,000 IDs, then the remaining 25k and put them into two pages in the workbook? -- nm" (Reading a Post)

SlickerTalk
Search Archives
The Leaderboard
The FAQ

Login
Create Account

Search Dr. S. Talk
TT/ST Wiki
How Well Do You Know ...

RSS Feed

Hosting by DigitalOcean

Support ST on Ko-Fi

Down to Post

Backboards:

Posts: 160

In response to "If I have an Access query that has 90k records, how can I export this to Excel 2003? -- nm" by Will Hunting

Dump the results into a table with an ID field, then pull the top 65,000 IDs, then the remaining 25k and put them into two pages in the workbook? -- nm

Posted by JaxSean (aka JaxSean) Jul 7 '10, 11:16

(No message)

Responses:

If you order the result set, you can do the same thing using SQL offset parameters, I think -- nm - Beryllium Jul 7, 11:16 1
- I know sql server doesn't have a row ID built-in, but is there a way to pull the "bottom 25000" records? - JaxSean Jul 7, 11:18

Post a message top

Replies are disabled on threads older than 7 days.