My boss creates monthly files, headcount data for our organization. I need to create a headcount report for each month. Right now i have to take his files and combine them in excel and add a date label to each row for that specific month. Anyway that file is getting pretty big and is soon going to be to big to handle.
How can i create a database in Access that will import his files and combine them into 1 database, keeping the "import month" (which is something I can manually add to the file before importing to access if needed). Would I do an append query? Im not sure how to create this? he also has a turnover report off this file which calculates the turnover percentage (average headcount/total turnover).. I would need to create this report as well. But i need the headcount database first..
Any ideas?