excel functions in Access

[dans0515]

Hey I am trying to take the functions I have in excel and try and
import them into access. I can only import the data. Is there anyway to
get the equations I have in excel and have them transfer or convert to
access?

 

[Guest]

No, you can't do that. Acess is not Excel and is is not a Spreadsheet.
Access table fields contain data, not formulas. Some functions in Excel work
in Access, but many don't.

If you are going to use Access, use Access, if not, stay in Excel.

 

[Baz]

Hey I am trying to take the functions I have in excel and try and
import them into access. I can only import the data. Is there anyway to
get the equations I have in excel and have them transfer or convert to
access?

Not really, no. Some Excel functions, but by no means all, have equivalents
in Access, but even so the way you use them in Access is not at all
comparable to the way you use them in Excel.

I've a horrible feeling that you are sitting looking at an Access table in
Datasheet view and, because it looks a bit like a spreadsheet, you are
thinking that it IS a spreadsheet. It isn't, not even remotely. An Access
table is a data repository (and a much better data repository than Excel),
but it is NOT a tool for manipulating or analysing data.