How to move the data from a table to another

Hi all Access Experts,



First of all, I am not a native english speaker, so please forgive me for my poor english.



My boss has assigned a task for me to move the details under a field name (eg:[Name]) in table 1 to table2 under another field name (eg:[InsuredName]).



Previously, the software I planned to use is Excel, but my boss says Excel cannot handle large data as the computer will be hanging.

So,he wants me to use Access to do the programming.

But I am definitely a newbie to Access.

I have some programming backgrounds (like C++) but it seems like I hardly understand how Access works! :banghead:

So can any Access expert here teach me how to do so that i won't get fired.



To get you the clear picture of what I want, I will paste some images here. I illustrate the process by using Excel but my job is making this work in Access.



Firstly, We will have the data like this.



Table1



Name PolicyNo Age Benefit

Chris 123 21 Death

Jane 456 34 TPD

Adam 789 55 DD



Secondly, we let the other staffs to key in which column to be mapped with the other.

Manually Key in (both columns)

Mapping Table:



Table1 Table2
Name InsuredName
Policy No Pol_No
Benefit InsuredBenefit
Age InsuredAge





Thirdly, the staff will run the VBA and result would be like this.



Table2
InsureName Pol_No InsuredBenefit InsuredAge
Chris 123 Death 21
Jane 456 TPD 34
Adam 789 DD 55



As you can see the new table(table2) , field number 3 is the same with the field number 4 in table1. There is something like copy and paste job, but user can decide how the arrangement for the new table is.



Any idea? I know this can be done in queries but as the boss wants it to be automated, what i can think of is VBA.



Appreciate if someone can help me on this. :confused:

How to move the data from a table to another