?
Solved

Pasting problems from Access to Excel

Posted on 2011-03-25
1
Medium Priority
?
403 Views
Last Modified: 2012-05-11
Two items. Not sure if they are related.

Generally when I try to paste data from an Acces query into Excel it goes smoothly. However sometimes (I can't detect a pattern) afer I copy the data from Access, the option to paste it into Excel is greyed out and I cannot paste the data.

I also am getting a  "cannot empty clipboard" message in Excel.

I thoughts about what's going on here and how to fix it?
0
Comment
Question by:pstewartrrm
[X]
Welcome to Experts Exchange

Add your voice to the tech community where 5M+ people just like you are talking about what matters.

  • Help others & share knowledge
  • Earn cash & points
  • Learn & ask questions
1 Comment
 
LVL 29

Accepted Solution

by:
leonstryker earned 2000 total points
ID: 35217628
Try hitting 'Esc'. If you're cursor in Excel is on the formula bar, Excel will not let you Copy/Paste to the spreadsheet.

Leon
0

Featured Post

Use Case: Protecting a Hybrid Cloud Infrastructure

Microsoft Azure is rapidly becoming the norm in dynamic IT environments. This document describes the challenges that organizations face when protecting data in a hybrid cloud IT environment and presents a use case to demonstrate how Acronis Backup protects all data.

Question has a verified solution.

If you are experiencing a similar issue, please ask a related question

My attempt to use PowerShell and other great resources found online to simplify the deployment of Office 365 ProPlus client components to any workstation that needs it, regardless of existing Office components that may be needing attention.
This article helps those who get the 0xc004d307 error when trying to rearm (reset the license) Office 2013 in a Virtual Desktop Infrastructure (VDI) and/or those trying to prep the master image for Microsoft Key Management (KMS) activation. (i.e.- C…
This Micro Tutorial will demonstrate the scrolling table in Microsoft Excel using the INDEX function.
Finds all prime numbers in a range requested and places them in a public primes() array. I've demostrated a template size of 30 (2 * 3 * 5) but larger templates can be built such 210  (2 * 3 * 5 * 7) or 2310  (2 * 3 * 5 * 7 * 11). The larger templa…

770 members asked questions and received personalized solutions in the past 7 days.

Join the community of 500,000 technology professionals and ask your questions.

Join & Ask a Question