I have a query that I do monthly and I usually just copy the results into an excel table. For some reason this month it is taking forever to copy these records. There is the same amount about 8000; I select all and then copy and it just says copying for over 30 minutes usually this takes less than a minute. I have reset my computer and I still have this problem any ideas also there are no new programs running, any ideas?
Tek-Tips is the largest IT community on the Internet today!
Members share and learn making Tek-Tips Forums the best source of peer-reviewed technical information on the Internet!
-
Congratulations derfloh on being selected by the Tek-Tips community for having the most helpful posts in the forums last week. Way to Go!
Access takes forever to copy data
- Thread starter Xzibit7
- Start date
- Thread starter
- #2
Just curious - do you run a query and then while viewing that query output you select all records then copy? If so, as a test, try changing your query to a "Make Table" query, then copy the table contents and see if that's faster.
You don't mention how many fields, or if the fields are very large, so it's hard to guess the amount of data involved.
Also, since this is the "first month" it has taken so long, did something change? More records? Larger records?
Have you run a Compact & Repair lately?
Learn from the mistakes of others. You won't live long enough to make all of them yourself.
You don't mention how many fields, or if the fields are very large, so it's hard to guess the amount of data involved.
Also, since this is the "first month" it has taken so long, did something change? More records? Larger records?
Have you run a Compact & Repair lately?
Learn from the mistakes of others. You won't live long enough to make all of them yourself.
- Status
Similar threads
- Locked
- Question
- Locked
- Question
- Locked
- Question