Transferring Excel Spreadsheet into Access

[Nancy]

I work in a Real Estate Brokerage Firm. We need to transfer our
current excel based spreadsheet into Access. Our goal is to utilize
Access for superior Database Management while maintaining Excel's
calculator functions. Is that feasible and if so, how?
Also can this be done in an HTML environment? Thanks.

 

[Jeff Boyce]

Nancy

From my perspective, Excel provides strong "calculator" functions, as you
describe it, while Access, as a relational database, offers strong database
functionality. These represent two different tools.

What about "Database Management" (whatever you mean by that) is it that
Excel isn't doing for you -- a way of checking to see if you need to migrate
to Access?

What kinds of "calculations" are you anticipating needing to do -- a way of
checking if Access built-in functions or additional coding could do what you
are trying to do (which isn't clear yet).

Have you considered keeping your data in Access, but exporting data sets to
Excel for analysis (?i.e., "calculator functions")?

Please bear in mind that Access is NOT a "big spreadsheet". To get the best
use of the capabilities Access offers, you may need to review your data
design and normalize it.

JOPO (Just one person's opinion)

Jeff Boyce
<Office/Access MVP>