Chapter 20. Using Access with Microsoft Excel

Spreadsheet and word-processing applications dominate the Windows productivity application software market. According to industry reports, more than 70 percent of all Windows installations in the business environment include a spreadsheet application. Microsoft Office 97, which includes 32-bit Excel 97 and Word 97, is likely to take over the dominant position of 16-bit Microsoft Office 4+ as Windows 95 and Windows NT 4.0 Workstation gain popularity. Spreadsheets include the capability to emulate some features of database managers, such as sorting ranges of cells that are defined as a worksheet "database."

One of the principal uses of Access 97 is the conversion of data in large worksheets to tables ...

Get Special Edition Using Access 97, Second Edition now with the O’Reilly learning platform.

O’Reilly members experience books, live events, courses curated by job role, and more from O’Reilly and nearly 200 top publishers.