Share this Page URL

Chapter 29. Using Excel with Access and ... > Using Access to Complement Excel - Pg. 741

Using Excel with Access and Other Databases 741 Although you might keep most of your data in Excel, if you work in a business, it's a sure bet most of the business's data is stored in a corporate database somewhere. If you work in a large company, that data is probably stored on a mainframe system running a database such as IBM's DB2, a Unix or NetWare system running Oracle Corporation's Oracle, or a Windows NT-based server with Mi- crosoft's own server database, Microsoft SQL Server. If you are really lucky, your company has recently purchased an Enterprise Resource Planning System (ERP), which purports to be the soup- to-nuts data storage and retrieval solution for your company. This chapter also shows you how to access the entire world of data outside your PC without leaving Excel's familiar environment. As you'll see, Excel is a champ at getting at the data you need, wher- ever it might be stored. If you work with large amounts of data, you'll also want to check out the next chapter to learn how to use Excel 2002's new analytical data processing features. They'll be a big help on tough data- analysis jobs. Using Access to Complement Excel Access and Excel do a good job of filling in each other's rough spots. If you need to work with long lists of data, for example, you'll appreciate the built-in Access tools that help make sure your infor- mation is entered without mistakes. The following sections cover how to decide when to stay with Excel and when to use Access. You'll also learn how to move your Excel data over to Access painlessly, and how to create Access forms and reports that work with Excel data. When to Use Access Instead of Excel