Results of Access queries not always copying reliable to excel

  • Thread starter Thread starter Andy S.
  • Start date Start date
A

Andy S.

I'm using Office 2000 SP 3 trying to paste the results of large queries
(between 5000 - 50,000 rows) to Excel and am having a problem with one
machine where the results don't always paste over. The workaround is to
close excel and access, then reopen them. I've tried clearing the clipboard
from Excel, can't find clear clipboard in Access to no avail.

I'm using a Dell P4 workstation with 512 MB of RAM. The machine is not
locking up, and there seems to be plenty of free memory. Any suggestions?
 
Hi, Andy.

Instead of cutting and pasting, try Tools, Office Links, Analyze It With
Excel.

Sprinks
 
I've actually tried that and doing an export. The frustrating part of the
problem is that is intermittent. Sometimes it copies over the results,
sometimes it doesn't. There aren't a lot of applications running on this
particular machine. I'm hoping there are settings or something somewhere
that can be checked. I saw on the Mac version of office, you can even
configure how much memory to allocate to clipboard.
 
Back
Top