Append query from two tables with different fieldnames -- easy linking?

[Jason]

I've got two different tables with similar data but the fieldnames are
different and laid out slightly different. Is there a quick way to build an
append query where maybe I could draw lines between each field to associate
them to one another? The access append wizard will only match up fields
with the same names, but I have probably 100 others that are different.

Is there a way to quickly associate say:

table1:
a
b
c
d

with table2:
d
c
a
b

where table1.a = table2.d, table1.b = table2.c, etc.
Can access or some other utility make this association for me quicker
(something graphically) to build an insert/append query? This will save me a
ton of work.

Thanks in advance!

[Pavel Romashkin]

If the number of fields is the same and field order is the same, a union
query should do what you want. It doesn't care about field names. If, on
the other hand, the field order is not the same, I think there is no
avoiding doing it by hand, one field at a time.

Pavel

Jason wrote:

I've got two different tables with similar data but the fieldnames are
different and laid out slightly different. Is there a quick way to build an
append query where maybe I could draw lines between each field to associate
them to one another? The access append wizard will only match up fields
with the same names, but I have probably 100 others that are different.

Is there a way to quickly associate say:

table1:
a
b
c
d

with table2:
d
c
a
b

where table1.a = table2.d, table1.b = table2.c, etc.

Can access or some other utility make this association for me quicker
(something graphically) to build an insert/append query? This will save me a
ton of work.

Thanks in advance!