Error trying to execute SQL statement with VBA

[HarrySpencer]

Hello

Sorry if this is in the wrong forum.

I'm trying to create a function to update and amend records in a table.

The update part works and updates existing records with new data but I'm getting an error with the insert part.

Might be my SQL, I found it in an example and edited but the error message doesn't give me an idea as to what the problem might be.

Run time error 3078
The Microsoft Office Access database engine cannot find the input table or query 'FALSE'. Make sure it exists and that its name is spelled correctly.

Nothing called 'FALSE' so not sure what that means?

    sSQL = "INSERT INTO Pupil_tb (PupilID,Class,PupilName,etc ) " _
    = "SELECT PupilImport_tb.PupilID, Class, PupilName, etc FROM PupilImport_tb " _
    & "LEFT JOIN Pupil_tb " _
    & "ON Pupil_tb.PupilID=PupilImport_tb.PupilID " _
    & "WHERE Pupil_tb.PupilID Is Null "
    
    CurrentDb.Execute sSQL, dbFailOnError

Any help is greatly appreciated.

 

[pr2-eugin]

Is the equals in the Second line a Typo? If not I think that might be part of the problem.. Try Debugging the Error..

 

[HarrySpencer]

That was a typo, thanks for the second set of eyes.

Thanks again, Harry

 

[pr2-eugin]

Did it solve your problem?

 

[HarrySpencer]

Yes that was the main problem and everything is now working after a little more editing.

Thanks for your help.

 

[pr2-eugin]

Glad to hear.. Good luck..