Importing Excel workbooks

[Brendan]

Hello, The setup: I have two excel workbooks with similar but not entirely
identical information. (Both track customer complaints. However, they both
have unique fields [one tracks monetary compensation and the other tracks
response time]). My objective is to combine the two worksheets and to
remove the duplicated information. Is there a way to have access do this for
me? It will take me days to copy and paste each field. Thank you in
advance.

 

[bhicks11 via AccessMonster.com]

Yes, if there is an ID field that relates both worksheets - import both
worksheets into two seperate tables. Make the field the primary key (ID).
Run a query that appends one table to the other - it will not append the
duplicated ID. If you don't have an ID or something to relate on post what
you do have.

Bonnie
http://www.dataplus-svc.com

Hello, The setup: I have two excel workbooks with similar but not entirely
identical information. (Both track customer complaints. However, they both
have unique fields [one tracks monetary compensation and the other tracks
response time]). My objective is to combine the two worksheets and to
remove the duplicated information. Is there a way to have access do this for
me? It will take me days to copy and paste each field. Thank you in
advance.