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
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