Append Query - Access 2003

[Abay]

Hello .. I imported data from excel to a new table, and tried to append it
to an existing table in my database. There are less fields in the import
(named Import) table, and all field names have the same names as those in
the existing table (named Clmaster). I keep getting the message that most
of the records, approx 12,000 are rejected due to validation violations. My
question .. how can I find out what kind of validation is going on.

The table has one primary key (got the msg that some had been rejected (200
odd) due to key violations, which is fine. All fields are defined as text,
so I am puzzled as to why it would have validation violations on these

I tried appending both tables to a new table, but got the same message.

I can run queries on the Import table with no problems, but just cannot add
its data to the Clmaster table.

Any help with this would be very much appreciated.

Abay

 

[pietlinden]

there are only a couple of reasons an append query won't work - data is
the wrong type or size to go in the field you're trying to put it in,
or you're violating validations in the table (foreign key constraints
etc).

 

[Abay]

Many thanks for your reply ... all fields are defined as text and field
sizes are the same in both tables. There are no index keys in the import
table and one primary key in the existing table .. <sigh>

Abay