"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