Is there a command to automate clearing the Office Clipboard?

[WMWebster]

We are exporting a large amount of data out of Access and into Excel and in
some cases exceeding the limitations of the Microsoft Office Clipboard. Is
there a command that can be used to clear the clipboard after each cut and
paste to avoid the clip board becoming too full? When it fills up in some
cases Office gives a "Blue Screen of Death" error.

I am not a programmer but am looking for some code to help a programmer on
my staff who is trying to program a report function we are trying to roll out
to users.

If there is no automated work around is there some third party clipboard
software that can be used?

 

[ANONYMOUS]

If you are importing from Access Database then copy/paste is not the
best way to do this.

Have you tried import in excel? Try this:

Open a blank Excel book;
Now go to: Data, Import External Data, New Database Query, MS Database
Query

Now just follow the instructions given on screen.

hth