Mege 2 files 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

 

[Steve Schapel]

Steve,

No programming required. Just make an Append Query to add the data from
one table to the other. Please post back if you need more specific help.

 

[Steve Jebson]

Thanks for reply Steve

I'm a bit of a newbie on this stuff, so some more specific help would be appreciate

Steve

 

[Albert D. Kallal]

Just use the query builder.

Create a new query, and when asked for what table, select the table you want
to COPY from. Then select query->append query. You are now asked for the
table where you want the data to go.

At this point, all of the mapping you talk about is available. You can
select what fields you want (ie: you don't have to select all fields). You
then can select what the target field is for each field (your mapping).

So, by using the query builder...you don't have to write code for the
mapping....