Insert Query in Access not grabbing data

I cannot figure out what is wrong with this Insert query. It keeps saying 0 rows updated but I know that the tblUpdatefiles has 6 more records than tblFiles. Can anyone offer a solution?

INSERT INTO tblFiles ( ID, [File Name], WebName, DatabaseName )
SELECT tblFiles.ID, tblFiles.[File Name], tblFiles.WebName, tblFiles.DatabaseName
FROM tblFiles LEFT JOIN tblUpdateFiles ON tblFiles.[File Name] = tblUpdateFiles.[File Name]
Where Not Exists (Select * from tblFiles where tblFiles.[File Name] = tblUpdateFiles.[File Name]);

Open in new window

jlcannonAsked:
Who is Participating?
 
Dale FyeCommented:
YOu state that UpdateFiles contains 6 more records than tblFiles, but you are selecting from Files, not tblUpdateFiles

So change the table in the field list of line 2, then change line 3 to"

FROM tblUpdateFiles LEFT JOIN tblFiles on tblUpdateFiles.[File Name] = [tblFiles.File Name] WHERE tblFiles.ID IS NULL

and then, delete the last line.  Should look like:

INSERT INTO tblFiles ( ID, [File Name], WebName, DatabaseName )
SELECT tblUpdateFiles.ID, tblUpdateFiles.[File Name], tblUpdateFiles.WebName, tblUpdateFiles.DatabaseName
FROM tblUpdateFiles LEFT JOIN tblFiles ON tblUpdateFiles.[File Name] = tblFiles.[File Name] WHERE tblFiles.ID IS NULL

Open in new window

0
 
jlcannonAuthor Commented:
thank you!
0
 
Dale FyeCommented:
glad to help.
0
Question has a verified solution.

Are you are experiencing a similar issue? Get a personalized answer when you ask a related question.

Have a better answer? Share it in a comment.

All Courses

From novice to tech pro — start learning today.