How do I convert formulas created in Excel to work in Access

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

Guest

I have created an Access table by importing an Excel spreadsheet. However,
the original Excel worksheet had several columns that used formulas to take
partial data from of other cells and conjoin that data in another cell. For
example: two cells, one a date 01/12/2006 and a second cell, time 12:45,
would be combined to read 08-Dec-1845 in a third cell. This is just one of
about ten formulas that I wish to import.

Is there an automatic method of converting formulas in Excel to code or
expression in Access (a form perhaps)
 
Mark

Excel is a spreadsheet, Access is a relational database.

If you need to do calculations (i.e. "formulas"), use the tool that does
those, i.e., Excel.

You will find that you won't get the best out of Access' features and
functions if you feed it 'sheet data.

While it is possible to import an Excel spreadsheet directly into a table in
Access, it isn't always such a good idea.

Have you looked into the topic of "normalization"?

You rarely need to store "calculated" values in Access... and there are some
very good reasons NOT to!

What is it that you want to do that makes you think Access will do a better
job than Excel?

I don't ask out of sheer curiosity, but because what you want to accomplish
will guide the responses you'll get from this newsgroup.

Regards

Jeff Boyce
Microsoft Office/Access MVP
 
Back
Top