I am not sure what you mean by "I want to create a query which would automatically put them into access".
There are processes that can load the data to Access, and then you can clean it there before moving it on. Is that what you are talking about? You can move it all into one table, and then query it from there.
Did any of that help?
Look it up at: http://wrox.books24x7.com