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

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

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


P: n/a
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.