Preserving Excel Formulas while importing spreadsheet into Access

[Guest]

Is it possible to import an Excel spread sheet into Access while preserving
spreadsheet formulas? I attempted to import and link using the wizard and
in both cases, the excel formulas are lost. The spread sheet in question has
several formulas which perform pretty basic addition and subtraction
functions (it would be annoying to redo these use VBA or a Macro). EX:
=E15+F15+G15+H15+I15+J15+K15+L15+M15+N15+O15+P15 and other such things along
those lines. Is it possible to preserve these formulas so that when info is
edited in Access, the spread sheet performs said functions? If not, can
someone suggest an easy way to accomplish the same end with Access? The type
of tables that I am creating don't look the best in form view, it's somewhat
superfluous really.

 

[Douglas J. Steele]

Access tables cannot have fomulae.

You could create a query that uses computed fields, but exporting that to
Excel would simply export the numbers, not the formulae.

 

[Guest]

Thanks so much for clearing that up!!! Creating a query that uses computed
fields sounds like a workable solution, but I have never done that before.
How do I go about it? Thanks again!

 

[Douglas J. Steele]

Create a query, and drag all of the fields that you require from table into
the grid.

In a blank column on the Field row, add something like:

Total: Field1 + Field2 + Field3

Total is whatever name you want assigned to the calculated field. Field1,
Field2, Field3 are the names of fields in your table.