merging similar data from multiple tables 1

[gemoon]

I am working on bringing data from excel into an access database. I have multiple, identically structured, tables which I have imported from excel. These tables all have "ID" and "comments" fields. I would like to bring the "comments" data from these multiple tables and match them up with "ID" data currently in an access table.

I could take multiple tables and append them one-by-one to a new table. Then I could do an update query with this table to bring the "comments" into the existing access table.

However, this process seem very round about. Does anyone have some suggestions on a more direct way of doing this?

thanks for any advice,

gemoon

 

[hamek1]

HY,
maybe you could use the UNION-statement in the SQL expression to put the tables together. The UNION-statement is not a standard part of the query-building interface of ACCESS, but very powerfull.

 

[gemoon]

thanks,
i tried the union statement and it works great.

gemoon