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?

[Product update] Infrastructure Analysis Tool is now available with Business Accounts.Learn More

x
I wear a lot of hats...

"The solutions and answers provided on Experts Exchange have been extremely helpful to me over the last few years. I wear a lot of hats - Developer, Database Administrator, Help Desk, etc., so I know a lot of things but not a lot about one thing. Experts Exchange gives me answers from people who do know a lot about one thing, in a easy to use platform." -Todd S.

Dale FyeOwner, Developing Solutions LLCCommented:
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

Experts Exchange Solution brought to you by

Your issues matter to us.

Facing a tech roadblock? Get the help and guidance you need from experienced professionals who care. Ask your question anytime, anywhere, with no hassle.

Start your 7-day free trial
jlcannonAuthor Commented:
thank you!
0
Dale FyeOwner, Developing Solutions LLCCommented:
glad to help.
0
It's more than this solution.Get answers and train to solve all your tech problems - anytime, anywhere.Try it for free Edge Out The Competitionfor your dream job with proven skills and certifications.Get started today Stand Outas the employee with proven skills.Start learning today for free Move Your Career Forwardwith certification training in the latest technologies.Start your trial today
Microsoft Access

From novice to tech pro — start learning today.