Home | Contact Us | FAQ | Search & Site Map | Link to Us
Sign In | Join | Other 45 Sites in Network
Home
DiscussionsAccessExcelInfoPathOutlookPowerPointPublisherWord
DirectoryUser Groups
Related Topics
Outlook ExpressInternet ExplorerWindowsMS Server ProductsMore Topics ...

MS Office Forum / Excel / New Users / January 2008

Tip: Looking for answers? Try searching our database.

Access -> Excel large Copy Paste fails

Thread view: 
Enable EMail Alerts  Start New Thread
Thread rating: 
Mike B. - 04 Jan 2008 16:12 GMT
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 - 04 Jan 2008 19:16 GMT
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

> 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
[quoted text clipped - 11 lines]
> this case it would be better operationally if I could get cut/paste to work.
> Any information to solve this would be helpful.  Thanks!
 
Sign In
Join
My Latest Posts
My Monitored Threads
My Blog
My Photo Gallery
My Profile
My Homepage

Start New Thread
Enable EMail Alerts
Rate this Thread



©2008 Advenet LLC   Privacy Policy - Terms of Use
This website includes both content owned or controlled by Advenet as well as content owned or controlled by third parties.