how to link excel to access ?

Thread view:

Enable EMail Alerts

Start New Thread

Thread rating:

Lujain - 21 Nov 2004 04:43 GMT

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

Reply to this Message

John Nurick - 21 Nov 2004 21:31 GMT

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

>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

--
John Nurick [Microsoft Access MVP]

Please respond in the newgroup and not by email.

Reply to this Message