Automate Files loaded in to Access Database, Write queries and Export Queries

I have 5 data files that are exported twice a day. I would like an automated import in to an access database, I also need query on this data and also an export of data into xls. I have database tables setup, just need some queries. The data is scraped off of several sites so not always clean...makes writing queries a little challenging for me. Also need to create a form to view and also input data.