Unable to COPY from Excel into FIND window in ACCESS

[vccsdsd]

frl> WIN NT and Office 2000

 

[JGH]

I frequently need to cross-check items that are in Excel
spread sheets and Access databases. A very convenient way
to do so has been to COPY the contents of a cell in the
Excel spreadsheet and PASTE the item into the FIND WHAT
section of the FIND & REPLACE window of Access. This has
worked without problems when working with the following
configurations:
WIN NT and Office 97
WIN NT and Office 2000
WIN 98 SE and Office 97.
Unfortunately since I converted to WIN XP PRO and Office
2002, the PASTE part of the operation does not work -
instead a message pops up saying "What's This", and I am
then forced to type the desired material into the FIND
WHAT window.
I would be very grateful for any advice on how to solve
this problem.

 

[Van T. Dinh]

It works fine on my computer (WinXP Pro, OfficeXP Pro).

Unless some one can come up with a simple explanation &
solution, you may need to do a big re-instal.

HTH
Van T. Dinh
MVP (Access)