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

  • Thread starter Thread starter Jason
  • Start date Start date
J

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!
 
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?
Click to expand...

ummm... the telepathic interface won't be released until 2013. Hold
your Microsoft stock until then.

How can Access determine which field matches with which? I'd just use
the query grid; you can base it on the source table, specify the
target table, and use the dropdown boxes on the "Append To" field
cells to select the appropriate target fieldname.
 
Back
Top