Append Query isn't working

  • Thread starter Thread starter steve12173
  • Start date Start date
S

steve12173

I have a main table (tblProspect) that has all records, there is also a
second table (tblTransition) with records that are imported from an Excel
spreadsheet. All of the fields in tblTransition match one of the fields in
tblProspect (there are more fields in tblProspect than tblTransition). I am
attempting to do an Append Query to add the new records from tblTransition to
tblProspect. When I run the query, I either get 0 records appended or, I get
an error saying there was a violation of a validation rule and no records are
appended. I have no vailidation rules

Any thoughts?
 
When you use an append query in the grid, where it says update to: that means
update to = the new value, the field to update to. Update to is the field to
update FROM.
 
Thanks, I got it working now.

Golfinray said:
When you use an append query in the grid, where it says update to: that means
update to = the new value, the field to update to. Update to is the field to
update FROM.
Click to expand...
 
Back
Top