link between access and excel (1 Viewer)

[medaccess]

Hi,
I have an access database in which I have some fields which should be calculated from 2-3 excel sheets for each record. I have a field in access in which I attach the excel sheets for each record. It is difficult to calculate data through a function or macro in excel and then manually enter the results to the access.
I wonder if anyone can help me how to figure it out through a code to tell access to go to the attached excel sheet for each record and run a macro and enter the retrieved result to the specified field in access.
Greatly appreciate your help!

 

[llkhoutx]

Have you tried linking the Excel sheets to Access and doing the calulation in an Access query?

 

[GaryPanic]

Be careful (make a back up of your D/b first)
I just tried this - and It slowed the d/b down and some of my forms fell over (and its the only thing i did to the d/b)
- It of just been me ....