Copy and paste from Access into Excel

T

traveler

I am having a problem with a simple copy and paste from Access into Excel. In version 97 a simple 30,000 record copy and paste took about 30 seconds. Now in XP it takes 20 minutes. I think it has to do with the new clipboard features and cant figure out how to shut it down all together. I am open to any suggestions

Thank
Traveler
 
S

Shao

Clipboard takes awhile to hold large amounts of data like
your 30,000 records. Try the Export to Excel or Analyze
with Excel. That might make things easier for you.
-----Original Message-----


I am having a problem with a simple copy and paste from
Click to expand...
Access into Excel. In version 97 a simple 30,000 record
copy and paste took about 30 seconds. Now in XP it takes
20 minutes. I think it has to do with the new clipboard
features and cant figure out how to shut it down all
together. I am open to any suggestions.
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Similar Threads

Paste to excel from word - auto format problem 1
Pasting a cell into bookmarked table from excel vba 1
Help with ACCESS paste from EXCEL 2
Advanced Filter/Copy & Paste disabled 2
Access 2007 Copy - Paste 1
Copy & Paste corrupts embedded file? 0
Paste Access into Excel 2
clipboard Data corrupted, cannot paste in Access 2

Top