store Procedure in access

[ThaiByThai]

Hello -

I working of a store procedure in access and i'm tying to update 3 addition fields to a table called tblapplicant. I already added the fields in the tbleapplicant - but when i modify the procedure the 3 new fields which [CVS SOB],[CVS COB] and [PLACE OF BIRTH], would not update into tblapplicant -- is there something i am missing here?



ALTER Procedure spuInserTable

As

INSERT INTO dbo.tblApplicant
(Social_Security_Number,Last_Name,First_Name,Middle_Name, [CVS SOB],
[CVS COB], [PLACE OF BIRTH], Location)
SELECT
tempImport.SSN,
tempImport.LAST_NM,
tempImport.FIRST_NM,
tempImport.MIDDLE_NM,
tempImport.[CVS SOB],
tempImport.[CVS COB],
tempImport.[PLACE OF BIRTH],

SUBSTRING(tempImport.CAPTURE_LOC,1,50)
FROM dbo.tblApplicant
RIGHT OUTER JOIN dbo.tempImport
ON dbo.tblApplicant.Social_Security_Number =
dbo.tempImport.SSN
WHERE (dbo.tblApplicant.Social_Security_Number Is Null)

return