How do I import of excel calculations to access?

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

Guest

I want to move data from Excel to Access and have various calculations (such
as tax, varied shipping charges per carrier, etc.) which need to be moved as
well. If I am moving the data over, what happens to the calculations? Can
they go in a calcualtion field in a table or do they have to go someplace
else?
 
Tables cannot contain calculations. However, you can put them into a query
that's based on the table, and use the query wherever you would otherwise
have used the table.
 
Douglas said:
Tables cannot contain calculations. However, you can put them into a query
that's based on the table, and use the query wherever you would otherwise
have used the table.
Click to expand...

Some calculations are easier to transfer than others. You can easily
handle, for example, calculations involving only fields in the current
Row or constants, such as a formula in F5 defined as "=D5*$H$2". In
this case you could refer to D5 by its field number, and $H$2 by its
value. But other cases get trickier, and sometimes they're so tricky
that VBA code (in an Access Module) might be called for. If you're
stuck with that, you might prefer to let Excel do the arithmetic, and
just set up an Access link to that table in Excel. The Excel table
would then have to be formatted properly for linking (surrounded by
blank rows and columns, etc.).

-- Vincent Johns <[email protected]>
Please feel free to quote anything I say here.
 
Back
Top