Copy more than 65500 records

P

pg8429

Can I copy more than 65500 records from Access 2007 to Excel 2007?
I get the message that the clipboard is full i.e. more than 65500 records
selected.
I assume this is the Windows clipboard.
I have tried the Office 2007 clipboard with the same result.
I am currenly running XP service pack 3
 
G

Gordon

pg8429 said:
Can I copy more than 65500 records from Access 2007 to Excel 2007?
I get the message that the clipboard is full i.e. more than 65500 records
selected.
I assume this is the Windows clipboard.
I have tried the Office 2007 clipboard with the same result.
I am currenly running XP service pack 3
Click to expand...

Have you tried the "Get External Data from Access" in the "Get External
Data" section in the Data Tab in Excel?
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Similar Threads

Outlook Backup issues 0
Can I install Office 2010 over Office 2007 2
Office 2007 Clipboard woes 2
Cannot Empty ClipBoard 0
Error message : Cannot empty the clipboard 5
Security Update for Microsoft Office 2007 suites (KB2687499) will not install. 0
PasteSpecial method of Range class failed Error 1004 8
Clipboard copy speed 0

Top