views:

40

answers:

2

All - I'm embarrassed to ask something that appears to be so rudimentary, but I'm stuck.

Using Access 2007, I ran a query against a single 84K row table to produce a result set of ~80K row. I can't copy/paste the result set into Excel (Access fails copy/pasting > 64K rows). When I right-click on the query and export, no matter what format I try, it only exports the first row (ID).

How can I get Access to export the entire result set? (I've tried highlighting everything, etc. I also tried using the 'External Data' ribbon, but that just exports the original table, not the result set from the query I ran.)

Thanks!

A: 

I ran a query, highlighted everything by clicking on the little arrow in the upper left, CTRL-C, opened Excel, CTRL-V. Exported the whole thing. (Granted I didn't have ~100k rows like you, but I don't understand why it wouldn't handle that too.)

Or is that not what you want?

John at CashCommons
Unfortunately, once it is > 65K rows, Access craps out and errors when copying. Not sure why, since Excel 2007 no longer has a 65K row limit... and I routinely copy/paste > 65K rows using other apps.
Mark
A: 

What if you copy 40,000 rows at a time to different tabs in your Excel file?

PowerUser