| | |
|
|
|
ms access merge tables |
|---|
| message from =?Utf-8?B?Y3JhaWc=?= on 12 May 2004 |
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 replied to =?Utf-8?B?Y3JhaWc=?= on 12 May 2004 |
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
|
| =?Utf-8?B?U0NITllERVM=?= replied to RobFMS on 12 May 2004 |
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
Or if you like point and click, try an APPEND query to get your info where it needs to be
|
|
Archived message: ms access merge tables (Microsoft Access)
