Microsoft may be IBM's arch nemesis, but iSeries users still need to use PCs and Microsoft software. Fortunately, the i5/OS and Microsoft Office work well together.
Interaction between two computers -- like an iSeries system and a PC -- does, however, require a coordination of efforts between the two machines. To help you with that, Chris Peters and Brian Singleton wrote the i5/OS and Microsoft Office Integration Handbook. In it they explain how to install and license iSeries Access connectivity software, ODBC, and OLE DB/ADO data access providers as well as to explain how to use them. They also cover how to access iSeries data with Microsoft Query, bring iSeries information into Word documents and labels, and analyze iSeries data with Microsoft Excel.
This month Search400.com is featuring a four-piece package on this subject:
- An article written by Chris Peters about the benefits of using MS Office in conjunction with your iSeries.
- A excerpt of the i5/OS and Microsoft Office Integration Handbook published by MC Press.
- A quiz to test how well you know how to retrieve iSeries data with Microsoft Query.
- An opportunity to receive a copy of the i5/OS and Microsoft Office Integration Handbook
All are available for free for Search400.com members.
So, what are you waiting for? Go ahead and begin exploring this great educational package.
- Microsoft computing: Integrating the iSeries and Microsoft Office
Traditionally, IBM and Microsoft have not been the best of friends, but ironically their respective business platforms make pretty good partners. Chris Peters, co-author of the i5/OS and Microsoft Office Integration Handbook, reviews the benefits of using MS Office in conjunction with your iSeries.
- Free Book Excerpt: i5/OS and Microsoft Office Integration Handbook, Third Edition -- Chapter 3
Download for free a complimentary copy of Chapter 3 of the i5/OS and Microsoft Office Integration Handbook, Third Edition written by Chris Peters and Brian Singleton and published by MC Press. This chapter, "Retrieving iSeries Data with Microsoft Query," helps you become familiar with ODBC and Query terminology while explaining how to install Query. Practical examples show you how to create, save, and use queries, how to join tables, and how to us filtering, grouping, totaling, and sorting.
This was first published in November 2005