Help merging tables.

[Ynot]

I have two tables I would like to merge. Table A has more column and
similar column names to table B. Both tables have autonumber keys. I can
drop the autonumber from table B. I have made several attempts and always
get an error "merge not processed" but no reason. Is there an easy way to
append table B to table A? There are several hundred rows in table B and
about 30 columns so copy and past doesn't work either.

 

[Guest]

Build a table that has all the fields you want as a final. You can copy the
structure of the one that has the most and then edit the design for the rest.


Use an append query.