ms access merge tables

[Guest]

Is there any way to merge two tables with same fields but overlapping records? I tried copy and pasting but am getting error messages I think because duplicate autonumbering between tables has created problems.

 

[RobFMS]

As long as the autonumber field has no relavance in another table or tables,
you can run a query to move the records from one table to another.

Insert Into Table1 (Field1, Field2, ... FieldX)
Select (Field1, Field2, ... FieldX)
From Table2

HTH

--
Rob

FMS Professional Solutions Group
http://www.fmsinc.com/consulting

Software Tools for .NET, SQL Server, Visual Basic & Access
http://www.fmsinc.com

-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-

Is there any way to merge two tables with same fields but overlapping

records? I tried copy and pasting but am getting error messages I think
because duplicate autonumbering between tables has created problems.