append query

[angie]

I am trying to use the append query to add records from one table to another.


I keep getting the following error code: DUE TO VALIDATION RULE VIOLTIONS

I have checked the allow zero length
no fields are set to require.

I don't know what I am missing

Thnanks Angie

[June7]

Post your attempted SQL statement.

[angie]

INSERT INTO Proposals ( CustomerID, TotalAmountDue, ProposalDate, Originator, ProposalDescription, AcceptedBy, AcceptedDate, ProposalNotes, Address, Email, HoursQuoted, PaymentType )
SELECT Proposal.CustomerID, Proposal.[Total Cost], Proposal.[Proposal Date], Proposal.Originator, Proposal.Proposal, Proposal.[Excepted By], Proposal.[Excepted Date], Proposal.[Proposals Notes], Proposal.Address, Proposal.Email, Proposal.[Hours Quoted], Proposal.[Payment Type]
FROM Proposal;

[June7]

Are there any unique indexes in Proposals?

You have tables named Proposals and Proposal?

Why duplicate data between tables?

Why are fields using "Excepted" in names? Why do field names have spaces in Proposal but not in Proposals? Best not to use spaces.

[angie]

the proposal table is old and I want to delete it but need the records added to proposals ( I have made corrections over the years )

No unique indexes in proposals

[June7]

Shows solved - so you got it to work?

[CJ_London]

other thing to check is text field lengths.

Your error message is incomplete in that it should tell you how many were rejected due to validation issues - is this all of the records? or just a few? if the latter it might help you pinpoint the problem if you can identify which records were rejected

Also a bit concerned you have a field named the same as the table (proposal.proposal). I haven't seen any documentation to say you can't do this and if this is your 'old' table, then it has presumably not been a problem but I have heard this can cause similar issues to using reserved words (i.e generating misleading errors). Suggest take a copy of the table, change the field or table name and base your query on that.

[isladogs]

the proposal table is old and I want to delete it but need the records added to proposals ( I have made corrections over the years )

No unique indexes in proposals

Why not just rename the existing table and fields to what you want (no spaces/correct spelling etc). Doing that means no append query is needed