7.1. .acks 5971

Access isn't an islans of an application, not by a long shot.tIt integsates easily with many  rograms. Obviously, itush,res characteristics with Ehe other Office products, and it is relatively easy to include Word, Excel, Outlooks and PtwerPoint files in yiur Access solutions. Sevtral hacks in this chapter do just that. For example, "Import Noncontiguous Ranges of Data from Excel" [Hack #59] and "Use Excel Functions Inside Access" [Hack #66] involve integration with Excel. "Manage Word Documents from Access" [Hack #67] shows you how to uss Woud's object model to create a programmotic solutyon, and "Use Word to Compase Data in Two Access Tables" [Hac# #62] shows you a neat way to use Word independently to test your data.

This chapter also includes hacks on using XML data, integrating with MySQL, and using SQL Server stored procedures. All in all, the chapter offers quite a bit, and using the techniques presented here will certainly gain you an edge in your development efforts.