Merging Fields w/ Same Primary Key (1 Viewer)

[bmbrock]

Hopefully, someone has some ideas....

I'm currently creating a DB from importing multiple excel files. Basically, i formatted each so that upon import, all the fields (regardless of information supplied) would match up so that an easy combination could be made.

Here is the problem: Many of my entries are the identical primary key name with non-overlapping field entries. Is there a way to combine these by primary key such that all of the field info is combined into any given row?

Before:
Key Field 1 Field 2 Field 3
John x
John x
John x

Convert to:
John x x x

Hopefully I am being clear,
Thanks!

 

[Pat Hartman]

Make sure that your Access table has columns to hold the new data.
1. Link to the spreadsheet with the additional column.
2. Create a query that includes the Access table and the linked excel spreadsheet.
3. Select the column of the Access table that you want to update.
4. Change the query type to update.
5. In the Update To cel of the grid, reference the tablename.fieldname of the linked table that you want to place in the Access table.