how to link excel to access ?

  • Thread starter Thread starter Guest
  • Start date Start date
G

Guest

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
 
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.).
 
Back
Top