Merge two tables together with same fields.

  • Thread starter Thread starter Miranhat
  • Start date Start date
M

Miranhat

i have import a csv file in a table in Ms Access. However i have a
table that created for projects. I now have to merge the data between
two table. For example i have to add the data from the imported table
to existent table. How do i do it?

Any idea and help will be appreciated.

Thank You!
 
If you want to add the records imported into an existing table, create an
"append" query. I would recommend making a backup of your database first
(if this is the first time you have played with append queries).

Append all the records from the imported table into your original table,
then delete the imported table.
 
Hi Rick,

Thank you for reply..I did the append query, this is what happen..I
have two tables..table A and B. A is the existing table where i have
other data in it. And table B from importing csv file. Now in my Table
A i have all 11 same fields from table B and 4 extra fields that
dosen't match with imported table B. Now my question is when i did the
append query it's taking all the fields from Table A and B add them
together. But i want to merge the fields from A and B just add the data
in to table A, not fields. From table B i don't want all the fields...i
only want same fields that i have in existing table A. So in table A i
have 15 fields. and Table B i have 23 fields. So It's uneccessary to
call all the fields. Where i can merge the table A and B together. I
did explained it correctly.

Thanks in Advanced.
 
If I understand, you are not doing a APPEND, you are doing an UPDATE.

Try creating an update query to find the matching records for each table and
adding just certain field values from one table to the other.
 
Back
Top