Pasting Data between tables

[AWS]

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?

 

[Rich_Lovina]

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.

 

[stephencadams]

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