ST Alpha - "If I have an Access query that has 90k records, how can I export this to Excel 2003? -- 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

If I have an Access query that has 90k records, how can I export this to Excel 2003? -- nm

Posted by Will Hunting (aka JoeMetz) Jul 7 '10, 11:11

(No message)

Responses:

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 - JaxSean Jul 7, 11:16 2
- 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
Excel 2003 has a row limit of 65,536 - you'll need to use multiple sheets. -- nm - decline Jul 7, 11:15 1
- if you have Excel 2007, the row limit goes to 1,048,576 -- nm - decline Jul 7, 11:16
I dont think you can, Excel 2003 is limited to 65k (or something around there) - Jovian Jul 7, 11:13
Excel 2003 still has the line limits? Hrmph. Well, you could find some way of paginating it or offsetting it and then have several sheets per workbook - Beryllium Jul 7, 11:12
can you export to Notepad first and then put it in chunks to Excel? - Mel Profit Jul 7, 11:12 1
- the print preview thingie might work that way, too. nm but: -- (link) - b. Jul 7, 11:14

Post a message top

Replies are disabled on threads older than 7 days.