I'm having trouble copying data from one table to another. In my older version of Access, this was easy: I joined two tables in a query, copied the source field using "select all", and pasted it in a new query.

I'm not getting any paste option in Access Office XP, however. The data is stuck on the clipboard, but I can't get it onto the desired table. (Yes, I've checked that the formatting is the same for the two fields, e.g., 'text' and 'text', number and number, etc.) Any ideas?

Do you want to paste all records and fields from table A to table B? If so just use Append Qry, display only table you wish to append from, enter new table name (B) at the prompt.

Copy and pasting data on Access 97 ( not using XP yet) can be done by using sendkeys
to paste the data back and answer any questions by ading Y or N on the end ofthe paste.
^C = Copy
^V = Paste