Table overwirte

**llgtjb001** · 02-18-2016, 08:58 AM

I have two tables. A2 has 3 data.

Click image for larger version.

Name: A2.png
Views: 8
Size: 17.0 KB
ID: 23727

A3 has 4 data.

Click image for larger version.

Name: A3.png
Views: 8
Size: 21.0 KB
ID: 23728

I want to A3 has 3 data as same as A2.
How do I overwrite the a3? What function do I use?

Thank you.

**orange** · 02-18-2016, 09:09 AM

??? Why???
In relational database you would not have multiple tables with the same info.

Please tell readers in plain English the business rationale for this.

**cyanidem** · 02-18-2016, 09:11 AM

What has changed since last post about the same issue?
https://www.accessforums.net/showthread.php?t=58058

**Bob Fitz** · 02-18-2016, 09:13 AM

Crosspost: http://www.access-programmers.co.uk/...d.php?t=284723

Please read: http://www.excelguru.ca/content.php?184

**llgtjb001** · 02-18-2016, 09:32 AM

Originally Posted by cyanidem

What has changed since last post about the same issue?
https://www.accessforums.net/showthread.php?t=58058

Changed some sentences because no one reply it anymore.

**llgtjb001** · 02-18-2016, 09:35 AM

Originally Posted by orange

??? Why???
In relational database you would not have multiple tables with the same info.

Please tell readers in plain English the business rationale for this.

Because I import new table that may has less data than previous one. Then I want to update A3 to the new one(A2 is the new table).

Table overwirte

Thread Tools

Table overwirte

Similar Threads

Matching People (Table 1) with Organizations (Table 2) Based Upon Interest (Table 3)

Using 'aliases' table as a lookup table to find the primary key 4 'main name' table

Link same table to two table.Dataentry in main form & sub-subform from same table

How to make query based on external access DB's table and the table in linked table?

Posting Permissions