469,271 Members | 841 Online
Bytes | Developer Community
New Post

Home Posts Topics Members FAQ

Post your question to a community of 469,271 developers. It's quick & easy.

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

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!
Nov 12 '05 #1
1 4026
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!

Nov 12 '05 #2

This discussion thread is closed

Replies have been disabled for this discussion.

Similar topics

3 posts views Thread by Dalan | last post: by
3 posts views Thread by Larry Rekow | last post: by
2 posts views Thread by john | last post: by
4 posts views Thread by franc sutherland | last post: by
reply views Thread by zhoujie | last post: by
reply views Thread by suresh191 | last post: by
By using this site, you agree to our Privacy Policy and Terms of Use.