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

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Similar Threads

Linking Access to Excel 1
Excel to Access 5
Relative path to linked excel sheets 1
The data in a linked Excel spreadsheet column is truncated to 255 characters in an Access database 0
Excel Create a New line in a Word Link without double "" around result 0
Excel How to Fix Damaged Excel File That Won't Open? 3
Linked Excel File 3
Import Excel 2010 table into Access 2010 - not listed as range 1

Back
Top