access and excel compatibility

  • Thread starter Thread starter Ruth
  • Start date Start date
R

Ruth

Hi there

I don't think this is possible, but hoping it is.... I have files in Excel
that serve as a forms to be filed out. (There are several forms, each having
it's own worksheet) Once they are filled out it calculates the costs using
the criteria giving, using various lookup tables and other formulas. I aslo
have a file in excel that is used to look up various other cost, there are
several worksheets and the format of each worksheet is pretty much a table.

I wanted to build a easy to use system in Access and want to know if it is
possible to have the forms in that excel in Access and they would work in the
same way. That they would look and function the same way, perhaps even be
the same forms themselves, and imported into Access, so they don't have to be
rebuilt.

Please let me know if this is possible or not, and if so, how it is done.
 
As a rule, excel formulas don't work in access. The forms would probably be
ok but you would have to re-do the formulas.
 
Hi there

I don't think this is possible, but hoping it is.... I have files in Excel
that serve as a forms to be filed out. (There are several forms, each having
it's own worksheet) Once they are filled out it calculates the costs using
the criteria giving, using various lookup tables and other formulas. I aslo
have a file in excel that is used to look up various other cost, there are
several worksheets and the format of each worksheet is pretty much a table.

I wanted to build a easy to use system in Access and want to know if it is
possible to have the forms in that excel in Access and they would work in the
same way. That they would look and function the same way, perhaps even be
the same forms themselves, and imported into Access, so they don't have to be
rebuilt.

Please let me know if this is possible or not, and if so, how it is done.
Click to expand...

I'll have to disagree with Golfinray here. Excel Forms are very different
beasts from Access Forms, and probably cannot be imported directly (the
underlying data model is altogether different).

Access is certainly capable of doing what you describe - but it *will be
different*. Access isn't "Excel on steroids", it's a relational data
programming environment. As such, you would not store any calculated values,
but rather use Queries (and/or Forms and/or Reports) to do calculations on the
fly, based on data stored in tables.

So yes... it may look the same, and give you the same results, but there'll be
a considerable amount of thought and work involved in getting there. I'd be
inclined to say it's worth the effort (but then I'm familiar with Access and
much less so with Excel, so I'm biased).
 
These forms you have in Excel, are they worksheets which you fill in or
Windows forms?

Can you give any examples of the formulae you are using in Excel which will
need to be translated into Access?

As pointed out by Mr Vinson, Access and Excel are very different products
but that should not put you off.
 
Back
Top