VBA Copy column data from one table and paste into another table

In my workbook, I have two tables (with different row numbers/column numbers) in a "database" sheet. Table1 has data input manually, which I want to paste via macro into Table2 in the same columns; ie. the data in Table1, Column "City" must be copied and pasted into Table2, Column "City". Table2 is empty and should not have to be cleared first (I think) because I will only need to run the macro once.

Can anyone point me in the right direction with this problem? I have been searching for some sample code and generally found the following:

Please Login or Register  to view this content.

However how can I modify this for tables instead of ranges, as well as defined columns within those tables?

Thanks in advance

After recording a macro of copying/pasting column data between the tables I get the following code:

Please Login or Register  to view this content.

Is there a better/faster method that does not involve Select?