Merge 2 tables with similar data structures ?

Steve Jebson

I have 2 Customer Tables from different sources that i would like to
merge into one master table. They have similar data but different
field names and field orders. Is it possible to extract the data from
one of the tables via some sort of mapping ? Outlook provides a nice
utility to map data into a Contacts folder but I can't find a similar
utility within Access. I have a programming background but not in VB
but I don't mind having a go if somebody can point me in the right
direction.

Thanks in advance,

Steve Jebson

Nov 12 '05 #1

Subscribe Reply

2003

Fletcher Arnold

"Steve Jebson" <st**********@b tinternet.com> wrote in message
news:e4******** *************** ***@posting.goo gle.com...

I have 2 Customer Tables from different sources that i would like to
merge into one master table. They have similar data but different
field names and field orders. Is it possible to extract the data from
one of the tables via some sort of mapping ? Outlook provides a nice
utility to map data into a Contacts folder but I can't find a similar
utility within Access. I have a programming background but not in VB
but I don't mind having a go if somebody can point me in the right
direction.

Thanks in advance,

Steve Jebson

You could approach this in a number of ways both with and without using
code, and you could look at using union queries, but this is how I might
handle it, for a quick conversion.

tblOne: CusName, CusCode, CusTel, CusFax
tblTwo: Customer, Phone, Fax, Code

Choose tblOne to be the master table.
Create a query based on tblTwo = "SELECT Customer, Code, Phone, Fax FROM
tblTwo"
Run query, select all records and copy
Open tblOne, highlight the new record (*) at the bottom of the table and
select Edit>PasteAppen d

Note you can make up columns if there are missing ones, eg.

SELECT Field1, Field2, "Missing" AS MyMissingField FROM tblMyTable

The important thing is to have the same number of fields.

Fletcher

Nov 12 '05 #2

R.A.Balder

It is easy in Access.
You go to query create new.
Add the table you wan't to add from.
Add all the fields in the top grid line
On the meny got to Query. Select Append query. You get a box up to enter
the table to append to.
The you map in the grid lines, the fields from the append from table, with
the fields in the append to table.
You can even create calculations or format changes on the fields in the
append from table.

A tip: Before you do it: make a copy of the original table, before you run
anything.

Brgds
Rolfern

"Steve Jebson" <st**********@b tinternet.com> wrote in message
news:e4******** *************** ***@posting.goo gle.com...

I have 2 Customer Tables from different sources that i would like to
merge into one master table. They have similar data but different
field names and field orders. Is it possible to extract the data from
one of the tables via some sort of mapping ? Outlook provides a nice
utility to map data into a Contacts folder but I can't find a similar
utility within Access. I have a programming background but not in VB
but I don't mind having a go if somebody can point me in the right
direction.

Thanks in advance,

Steve Jebson

Nov 12 '05 #3

Similar topics

12652

Creating a mail merge document using C#.

by: campwes | last post by:

Hey, all. I'm trying to develop a C# app that creates Word 2003 mail merge documents with an Oracle 9i database as the datasource. I used the following as an example of how I can start out: http://support.microsoft.com/default.aspx?scid=kb;EN-US;301659 The problem is that the code provided doesn't allow me to add more users to the mail merge data file. When I try to add an additional user with the following code, I get this error...

.NET Framework

1755

Merge Repliction - Run Stored Procedure when merge agent starts

by: tedd_n_alex | last post by:

I have database on SQL Server 2000 set up with a merge publication. This publication is configured with a number of dynamic filters to reduce the amount of data sent to each client. Each client has an anonymous pull subscription. The merge process can be triggered by the windows sync manager and my application. To improve performance I have created some helper tables to hold the mapping between user login and primary keys of selected...

Microsoft SQL Server

5156

Collections, Mail Merge and Word FormFields

by: Darryl Kerkeslager | last post by:

I hope that although this is 25% Access and 75% Word, that someone will know ... The whole problem here arises because 1) Microsoft acknowledges an 'issue' wherein TextInput type FormFields are lost when doing a MailMerge and 2) the fix that they have proposed is both inadequate and won't work from Access. http://support.microsoft.com/?kbid=286841 The part of the code below that actually performs the merge is great; the core of it is...

Microsoft Access / VBA

1799

Mail Merge problems using Word 2003 and Access 2000

by: Darragh | last post by:

I'm encountering some serious problems trying to set Access 2000 querys (parameters and views) as data sources for my mail merge documents (Word 2003). After spending hours scouring the web for some existing help and coming up with nothing, its time to admit defeat and ask here ! Trying to set the data source to a preexisting query via DDE results in an 'Unable to establish DDE connection' - similar to the error described at...

Microsoft Access / VBA

11348

command line mail merge from mysql db

by: cdelarte | last post by:

I would like to be able to mail merge records from multiple mysql tables using a simple template, preferably via a command line script. MSWord mail merge via ODBC will not work for me as it only supports a single table. Are there any utilities or simple scripts avaialble that would accomplish this?

MySQL Database

2605

Help with Merge and INSERT/UPDATE commands

by: John Cosmas | last post by:

I have a DATATABLE which I have populated in my application, and I need it written out to a particular table I specify in my ACCESS database. My code works to the point of the MERGE and UPDATE, but it creates exactly the number of BLANK records per the populated DATATABLE. Here is my code... pstrDestinationTable = "tws_tbl_Case_Scanner_" & GetDateTimeStamp() pstrSQL = "SELECT * INTO " & pstrDestinationTable & " FROM...

Visual Basic .NET

1521

Merge data in SQL Server databases

by: ammie | last post by:

I have two databases with identical tables structures. I need to merge the data in both databases without implementing merge replication. Can someone tell me what script to run that will compare the data in those tables? First I know the script has to search for data that doesn't exist in one table, the copy that over from the table that has extra rows. Thanks Ammie

Microsoft SQL Server

944

Merge data in SQL Server 2000

by: kunjan reshamiya | last post by:

Hi, I want to merge two databases in SQL Server 2000. Can you help me out regarding the same. For e.g. I have Database A and Database B, both containing the same tables and same number of tables but different data. I want Database C to have data from both Database A and Database B.

Microsoft SQL Server

2182

Probelm with DataSet Merge and GetChanges

by: Dave.Womer | last post by:

All, I'm having an issue merging datasets. It seems everytime I peform a merge of new data on existing data all of the rows of the existing data are modified even if the new data does not change. Is this normal behavior? Here is an example of what I'm finding: DataSet dsExisting = new DataSet();

C# / C Sharp

8394

What is ONU?

by: marktang | last post by:

ONU (Optical Network Unit) is one of the key components for providing high-speed Internet services. Its primary function is to act as an endpoint device located at the user's premises. However, people are often confused as to whether an ONU can Work As a Router. In this blog post, we’ll explore What is ONU, What Is Router, ONU & Router’s main usage, and What is the difference between ONU and Router. Let’s take a closer look ! Part I. Meaning of...

General

8732

Maximizing Business Potential: The Nexus of Website Design and Digital Marketing

by: jinu1996 | last post by:

In today's digital age, having a compelling online presence is paramount for businesses aiming to thrive in a competitive landscape. At the heart of this digital strategy lies an intricately woven tapestry of website design and digital marketing. It's not merely about having a website; it's about crafting an immersive digital experience that captivates audiences and drives business growth. The Art of Business Website Design Your website is...

Online Marketing

8605

Discussion: How does Zigbee compare with other wireless protocols in smart home applications?

by: tracyyun | last post by:

Dear forum friends, With the development of smart home technology, a variety of wireless communication protocols have appeared on the market, such as Zigbee, Z-Wave, Wi-Fi, Bluetooth, etc. Each protocol has its own unique characteristics and advantages, but as a user who is planning to build a smart home system, I am a bit confused by the choice of these technologies. I'm particularly interested in Zigbee because I've heard it does some...

General

7327

AI Job Threat for Devs

by: agi2029 | last post by:

Let's talk about the concept of autonomous AI software engineers and no-code agents. These AIs are designed to manage the entire lifecycle of a software development project—planning, coding, testing, and deployment—without human intervention. Imagine an AI that can take a project description, break it down, write the code, debug it, and then launch it, all on its own.... Now, this would greatly impact the work of software developers. The idea...

Career Advice

6164

Access Europe - Using VBA to create a class based on a table - Wed 1 May

by: isladogs | last post by:

The next Access Europe User Group meeting will be on Wednesday 1 May 2024 starting at 18:00 UK time (6PM UTC+1) and finishing by 19:30 (7.30PM). In this session, we are pleased to welcome a new presenter, Adolph Dupré who will be discussing some powerful techniques for using class modules. He will explain when you may want to use classes instead of User Defined Types (UDT). For example, to manage the data in unbound forms. Adolph will...

Microsoft Access / VBA

5632

Couldn’t get equations in html when convert word .docx file to html file in C#.

by: conductexam | last post by:

I have .net C# application in which I am extracting data from word file and save it in database particularly. To store word all data as it is I am converting the whole word file firstly in HTML and then checking html paragraph one by one. At the time of converting from word file to html my equations which are in the word document file was convert into image. Globals.ThisAddIn.Application.ActiveDocument.Select();...

C# / C Sharp

4304

Windows Forms - .Net 8.0

by: adsilva | last post by:

A Windows Forms form does not have the event Unload, like VB6. What one acts like?

Visual Basic .NET

1955

How to add payments to a PHP MySQL app.

by: muto222 | last post by:

How can i add a mobile payment intergratation into php mysql website.

PHP

1615

Comprehensive Guide to Website Development in Toronto: Expert Insights from BSMN Consultancy

by: bsmnconsultancy | last post by:

In today's digital era, a well-designed website is crucial for businesses looking to succeed. Whether you're a small business owner or a large corporation in Toronto, having a strong online presence can significantly impact your brand's success. BSMN Consultancy, a leader in Website Development in Toronto offers valuable insights into creating effective websites that not only look great but also perform exceptionally well. In this comprehensive...

General