How to append?

[zhuanyi]

Hello,
Say for example I have two huge tables I want to append together, out of the 200 fields, 190 of them have exactly the same name and will be mapped to exactly the same place, but the rest 10 do not have the same name although they do have a corresponding mapping to the target table (say field: "Last Name" mapped to field name "LName" and so on), now, one way to write the SQL string is of course to map the field one by one, but is there anyway I could just write out the mapping of the 10 fields that are different and save the work to write out the mapping of the rest 190 fields? Thanks a lot!

regards,
Anyi

 

[modest]

You could just do it in two queries. The append for the names that are the same and then an update, to update the values of the 10 fields.

 

[zhuanyi]

But how can I exclude those 10 fields first? Is there something in VBA that says append table for all but these 10 fields? Thanks a lot!

 

[modest]

You dont need to exclude those fields because they will be updated with the next query anyhow.

The querybuilder makes it relly easy to append fields with the same names.