how to link excel to access ?

L

Lujain

i am doing an accounting small system and i need to use the formulas that can
be used in excel but in the access DB.so i would like to know how i can link
the excel sheet with the access DB and if there is any other solution in
access that i can use formulas(mathmatical formulas) without linking to excel
thanks
 
J

John Nurick

Hi Lujain,

As you've discovered, Access tables cannot include formulas. Instead,
use queries, which can include calculated fields that perform similar
functions (including arithmetic, totals, averages, etc.).
 
Top