Access -> Excel large Copy Paste fails

[Mike B.]

I have an unusual situation where a user is attempting to copy a large
amount of data from Access 2003 SP2 -> Excel 2003 SP2 on a windows 2003 sp2
(i386) server. Specifically the dataset it 15,683 rows of data. I can see
the copy run as the blue status bar runs across indicating the copy process
is running for 8-10 seconds. When it finishes I paste into a blank new
spreadsheet in Excel and it runs for a some time - maybe 30-45 seconds - an
error pops up "Microsoft Office Excel cannot pasted the data". I only have
2003 server and office installed along with the latest Microsoft updates (no
other apps at all). When I try this copy/paste in the same version of
access/excel in Windows XP SP2 OS it works fine so I'm guessing there may be
some buffer parameter in the XP OS that makes that clipboard able to process
more data. I tried some variations of this and it fails on office 2007 as
well. If I use the export to excel feature in Access it works OK but in
this case it would be better operationally if I could get cut/paste to work.
Any information to solve this would be helpful. Thanks!

 

[CLR]

I don't know why you are experiencing your problem.....there can be other
variables of course, such as RAMsize of the various machines, in some weird
cases, screen resolution, etc.........but personally, my prefered method of
transfering the data from Access to Excel would be to write a macro to make
an MSQuery to go and get the info I wanted from the Access file and return it
to Excel.

Vaya con Dios,
Chuck, CABGx3