append query

[Guest]

I have two tables Table 1 and Table 2. I am trying to append Table 2 to table
1. Table 2 has one extra field that table 1 does not have. When I execute the
append query, it gives the following message:
"The INSERT INTO statement contains the following unknown field name: <field
name>. Make sure you have typed the name correctly, and try the operation
again. Error 3127)"
My understanding was that an append query can append records even when some
of the fields do not exist in the other table

 

[Jeff Boyce]

If Table1 doesn't have the extra field, why are you trying to append it?

Are you using the "*" expression to mean "all of the fields" from Table2?
You may have to individually name each field that corresponds.

Regards

Jeff Boyce
<Access MVP>

 

[John Spencer (MVP)]

The destination table MUST have a field for each field from the source you are
trying to put into it.

A MAKE Table query automatically builds the structure and then inserts the records.

There must be a one to one field correspondence in an append query.

 

[Guest]

Do the names of the matching fields also have to be exactly the same

 

[John Spencer (MVP)]

No the NAMES of the field do not have to match.

The POSITION and DataTypes do have to match.

Perhaps you could post the SQL of the query that fails. That would be a start