The OS/400 and Microsoft Office 2000 Integration Handbook--Second Edition
Authors: Brian Singleton and Chris Peters
Now you can use Client Access Express to combine the presentation capabilities of all versions of Microsoft Office (including Office 2000) with the database capabilities of the iSeries or AS/400 to provide your company with the best of both worlds. MC Press has completely updated its perennial best-seller, The AS/400 and Microsoft Office Integration Handbook, to reflect all the changes and enhancements of Client Access Express and Office 2000.
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 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.