I5/os And Microsoft Office Integration Handbook

In this the third edition of the perennial bestseller iSeries gurus ChrisPeters and Brian Singleton have completely updated this essential resource toreflect al... » 

In this the third edition of the perennial bestseller iSeries gurus ChrisPeters and Brian Singleton have completely updated this essential resource toreflect all of the latest changes and enhancements of iSeries Access andExpress Client and Microsoft Office. Now you can use iSeries Access or ExpressClient to combine the presentation capabilities of all versions of MicrosoftOffice with the database capabilities of the i5iSeries to provide your companywith the best of both worlds.Tasks that used to be almost impossible are now an easy reality...if you knowthe integration secrets revealed in this book. Discover how to use your iSeriesoutput with PC dataformatting tools make visually appealing reports usingiSeries data use visual query tools to point and click to create sophisticatedinformation output analyze and summarize the detailed and often cumbersomeiSeries reports tap into the power of Microsofts powerful Universal DataAccess using ADO.NET ODBC and OLE DB and much more.Singleton and Peters provide you with the essential knowledge you need to useiSeries Access or Express Access as a means to integrate iSeries or AS400 datawith Microsoft Office applications. i5OS and Microsoft Office IntegrationHandbook Third Edition covers installing and configuring iSeries Access orExpress Client using ODBC to seamlessly integrate iSeries with MicrosoftOffice and leveraging the iSeries Access data transfer function. The book alsoexplains how to bring data from the iSeries to your PC by using NetServer TCPIPs FTP file transfer function andor Universal Data Access with OLE DB andADO.NET.Other chapters of the book explore the multitude ofMicrosoft Office functionsby devoting a specific chapter to each Office application to show you how touse each function with the i5iSeries. Youll learn how to use Excel WordQuery Access and Outlook to generate spreadsheets mailing labels formletters and envelopes to «