By using this site, you agree to our updated Privacy Policy and our Terms of Use. Manage your Cookies Settings.
435,395 Members | 2,524 Online
Bytes IT Community
+ Ask a Question
Need help? Post your question and get tips & solutions from a community of 435,395 IT Pros & Developers. It's quick & easy.

Merge 2 tables with similar data structures ?

P: n/a
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
Share this Question
Share on Google+
2 Replies


P: n/a
"Steve Jebson" <st**********@btinternet.com> wrote in message
news:e4**************************@posting.google.c om...
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>PasteAppend

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

P: n/a
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**********@btinternet.com> wrote in message
news:e4**************************@posting.google.c om...
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

This discussion thread is closed

Replies have been disabled for this discussion.