Hey everyone,
I have an access database in which I have some fields that are calculated from 2-3 excel sheets for each individual record.
I have fields in which I attach the excel file for each record.
It is very difficult to calculate the values for each record using functions in excel and then manually entering the values for each record.
I wonder if anyone can help me to figure it out by a code to program the access to automatically calculate those values from excel and put them on the specified field for each individual record.
Greatly appreciate it!