How to copy Table2 columns in to Table1 ?

Hi all,

I have design table1, the table1 have 10 columns ex: slno, EMP_ID, EMP_Name, EMP_loc, EMP_designation, EMP_Status.

I have imported an excel file(with formula acimport) have EMP_ID, EMP_Designation and some other date...after importing this excel in to access it will be coming in to table 2....If I use the DoCmd.CopyObject then table1 is replacing with table2 so I have lost table1...

How to replace Table2 columns( Emp_ID and Emp_Designation) into Table1 columns of Emp_ID and EMP_Designation

Emp_ID is in number format and Emp_Designation is in Text

format.................I have given a command button for Importing excel(it's works fine) and given another command button

click for Replace columns .......Please Help me..........Thank you

Regards,
Sai

If I use the DoCmd.CopyObject then table1 is replacing with table2 so I have lost table1...

Are you wanting to keep the data in table1 and have table2 data added to it?

If this is the case and what you are asking, then you will need to do an append query.

Here is an example of how to do that

http://www.techonthenet.com/access/t...h/basics11.php