• Status: Solved
  • Priority: Medium
  • Security: Public
  • Views: 230
  • Last Modified:

mdb database merge two table

I have a database from one campaign and I made another campaign and collected more data,
I want to merge them,

I want to use the first table and import the other one on it,
How can I merge my two table on mdb database ?
0
Braveheartli
Asked:
Braveheartli
1 Solution
 
cascader_grCommented:
What do you mean by merge? Are there common records (based on a key column)? If there are, could you please post the schema of the tables and identify the key column(s)? If not, you can just insert the second table into the first with:

Insert Into OldTable
Select * From NewTable
--Assuming same table schema

Open in new window

0

Featured Post

Free Tool: IP Lookup

Get more info about an IP address or domain name, such as organization, abuse contacts and geolocation.

One of a set of tools we are providing to everyone as a way of saying thank you for being a part of the community.

Tackle projects and never again get stuck behind a technical roadblock.
Join Now