Please See ISBN 1583470573 for 3rd Edition
Tasks that used to be almost impossible are now an easy reality...if you know the integration secrets that authors Brian Singleton and Chris Peters reveal in this book. Find out how you can use your iSeries output with your PC data-formatting tools, make visually appealing reports using iSeries data, use visual query tools to point and click to create sophisticated information output, analyze and summarize the detailed and often cumbersome iSeries reports, tap into the power of Microsoft's powerful new Universal Data Access using OLE DB and ActiveX Data Object (ADO), and much more. Singleton and Peters provide you with the essential knowledge you need to use Client Access Express as a means to integrate iSeries or AS/400 data with Microsoft Office 2000 applications. The OS/400 and Microsoft Office 2000 Integration Handbook covers installing and configuring Client Access Express, using ODBC to seamlessly integrate iSeries with Microsoft Office, and leveraging the Client Access Express data transfer function. The book also explains how to bring data from the AS/400 to your PC by using NetServer, TCP/IP's FTP file transfer function, and/or Universal Data Access with OLE DB and ADO. Other chapters of the book explore the multitude of Microsoft Office functions. The authors devote a specific chapter to each Office application to show you how to use each function with the iSeries or AS/400. You'll learn how to use Word, Query, Excel, Access, and Outlook to generate mailing labels, form letters, and envelopes; to download data into spreadsheets; to produce queries and perform data retrieval; to create beautiful, sophisticated reports; and much more. If you have PCs attached to your AS/400, this book has the essential information that will allow you to harness the power of Microsoft Office and exploit the AS/400 database.