Unique "ID" problem in Append Query (1 Viewer)

[TonyT]

Hi,

I am having a problem with the Append Query!!

I have a table in MS Lists that I am importing into Access (all ok with that!), the issue is that because Access and Lists are both using a number as the "ID" I cannot merge the two table into one table as the same Unique ID appears in both the Access table and the List table. How can I merge two tables with the same ID and keep both records?

 

[tvanstiphout]

Add another column, to indicate if the data came from tableA or tableB.

 

[Pat Hartman]

How can I merge two tables with the same ID and keep both records?

You need a new PK. Use an autonumber. If you need the old value for reference, add two columns. OldPK and Source