Excel has many powerful built-in functions for such things as financial and statistical analysis. If one wants to do the same type of analysis in Access, one can do one of the following three things: purchase an off-the-shelf code solution, write their own code for analysis, or use automation to tap into Excel's functions from inside Access. This paper shows how to tap into Excel via automation and use spreadsheet functions, saving time and money over the other options. This hack involves Access working hand in hand with Excel, so one needs to make sure Excel is installed on the machine on which the database will be running. This is a safe assumption in most corporate environments.
Did you find this white paper useful?
3 out of 7 users found this white paper useful
Related white papers
Delivering Affordable Information Management Functionality: Oracle Database Standard Edition One
Databases have become key in enabling businesses to efficiently manage their data assets and to effectively use information to better understand their businesses. This document considers the question of what...
Choosing a Reliable and Powerful IT Infrastructure at a Price You Can Afford
This whitepaper provides an overview of the challenges midsize organizations face, and how Oracle products can help them overcome those hurdles. Read this whitepaper to learn how midsize organizations like...
Database Consolidation Makes New IT Initiatives Possible
The Issue: The proliferation of databases is Preventing money and staff from being devoted to new IT initiatives.Read this recent AMR Research survey which found that companies are reducing the...
Database Consolidation: Reducing Cost and Complexity
The Bottom Line: Database consolidation projects offer companies the hope of lower costs, greater ease of database administration, and the chance to improve the quality of their database technology by...
Oracle Database: 11g Standard Edition ONE
Oracle Database 11g Standard Edition One is a full-featured data management solution ideally suited to the needs of fast-growing businesses. It is easy to install on Windows and Linux operating...
Oracle Database: 11g Standard Edition
Oracle Database 11g Standard Edition is a full-featured data management solution ideally suited to the needs of midsized businesses. It is easy to install on Windows and Linux operating systems, easy...
Making the Case for Oracle Database on Windows
Read this Ovum Summit paper to see why one of the best-kept secrets in the IT industry is the depth of support Oracle offers to customers deploying its databases on...
