Microsoft Access can't append all the records in the append query.

[EmileEA]

Hi all,

I found numerous threads online about my problem but the I'm very new to access and therefore it's hard to understand.

I'm having the following problem with my Access Database.

Microsoft Access set 0 fields to Null due to a type of conversion failure, and it didn't add 15 records to the table due to key violations, 0 records due lock violations, and 0 records due to validation rule violations. Do you want to run query anyway?

I'm using Acces 2013.
Normally I append this query every week without problems untill this week.

Can anyone please help me explain in baby language how this problem occurs and how to resolve it without losing data.

Many Thanks,

Emile

 

[EmileEA]

FYI

Here is MY SQL for the to append query

INSERT INTO EUREKAList ( [Item Number], [Item Title], Platform )
SELECT WeekEUREKA.Itemnumber, WeekEUREKA.Title, WeekEUREKA.Platform
FROM WeekEUREKA LEFT JOIN EUREKAList ON WeekEUREKA.Itemnumber = EUREKAList.[Item Number]
WHERE (((EUREKAList.[Item Number]) Is Null));