Adding data to a table for other existing tables

[mimma]

Hi, I used to use a e-mail marketing software that had a limit of 1000 records per mailing list and therefore I have about 10 different mailing lists in 10 different access databases. I am now going to use a new software that does not have these limitations and want to put all the data from the existing tables into one table in my central databse. I have imported the tables fine into the database but don't know how to unify the tables into one table. I have tried a query but it repeats the data over and over again and this does not work. The e-mail address fields are unique and are the primary key so as not to have duplicate e-mail address. I have tried copying and pasting the field columns but it is only possibile to paste one field column at a time. So for example I can copy and paste the e-mail address field but the firstname and surname associated to those e-mail addresses cannot be pasted. Any help would be appreciated!

 

[WayPay]

If you want to paste multiple columns, select those columns in the table you want to paste into, then paste.

 

[neileg]

Or use an append query.