Import Data From Access! Please Help!!

Its been a while since i have posted however I have a quick question that hopefully requires a simple answer... I am trying to build a query from excel that gets data from access... The thing is i want 2 variables in the query so people can choose what database they extract data from... Here is my code

Please Login or Register  to view this content.

Lets say "NewFN1 = C:/db.mdb"
and FilePath = C:/

I cant get this to work... Any ideas?

Got it to work, if anyone was interested here is the code

Please Login or Register  to view this content.