how i can link access with multiple excel ??

[crazycat]

hello

im face a problem with link multiple excel file with one access database

for more information :
1- i have 27 excel file to employee that contain account number
2- this 27 excel file store in folder with date of day ( ex , 1(12), ...(15(12)... 31(12 ) and in each day i fill the exel file with data
3- in each day i should transfer the net account in many thing in this file to other excel file to show the net month account
4- i need to make access database for each emp that can take this numbers form the excel and put it in access database automatically .

so the problem is to take the number from each month day and put it in one table


please help me