A little new at AccessMacros, my problem is 4 tables importing to one where field names vary but contain same data type e.g.
ForeignDbase.1stname -> Mine.Firstname
ForeignDbase1.Fname -> Mine.Firstname
Is there a Macroprompt to allow field-matching?
If I bring in each table separately should I then use an Append in Macro to field-match?

If anyone reads this, the sometimes impatient Richard has solved his own problem with the OpenQuery demand, and by setting up 5 Transfer Database lines in my macro.
Although they all transfer to sequential table names e.g. table1, table2, etc. it appears that I then just match my Open queries to the new table names and then apply append.
Any comments will always be thankfully appreciated.