How can I increase the size of the clipboard in Windows 7?

Question

How can I increase the size of the clipboard in Windows 7?

While copying large amounts of data, I get the following error:

Item to large for Clipboard.

Answer 1

How to increase the size of the Clipboard:

1. Click the Start button. Type sysdm.cpl into the search box and press the Enter key.
2. Click the Advanced tab in the System Properties window. Click the Settings button under the Performance label header.
3. Click the Advanced tab in the Performance Options window. Under the Virtual Memory header, click the Change... button.
4. Clear the check box next to the Automatically manage paging file size for all drives option. This disables automatic "Virtual Memory" settings in Windows.
5. Enter a value for the size of the new paging file. Enter a value larger than the current paging file size in the "Maximum Size" field (enter the value in megabytes). Click the Set button and then OK.
6. Restart the computer for the new "Virtual Memory" settings to take effect. The Windows Clipboard now stores more data when copying and pasting between applications.

Reference: I need to increase the clip board size in Word

A detailed blog with screenshots :http://sforsuresh.in/increase-size-clipboard-of-windows-10-7/

Answer 2

Even after setting the Swapfile (Virtual Memory) to 65GB, I can still not copy and paste more than 65000 lines from Access to the Clipboard.

However, I can copy and paste more than 65000 lines in Excel easily. So the issue lies with Access not being able to copy enough rows to the Clipboard.

I have been searching for the solution since 2013. The problem seems with Access not being able to transfer more than 65000 rows to the Clipboard.

The only way presently is to create a query, then right-click on it and export to Excel.

Once the data is in another format, you can select all rows, and copy and paste from there.