
	Home > The iSeries and MS Office make good partners

Learning Center:

EMAIL THIS

The iSeries and MS Office make good partners

03 Nov 2005 | Search400.com

Digg This!

StumbleUpon

Del.icio.us

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.

Know-IT-All Chapter Quiz:
i5/OS and Microsoft Office Integration Handbook, Third Edition

Think you know all there is about retrieving iSeries data with Microsoft Query? We challenge you to test your skills by taking our latest quiz. Share the results with us and get a chance to win a copy of i5/OS and Microsoft Office Integration Handbook, Third Edition written by Chris Peters and Brian Singleton and published by MC Press.

All answers to this quiz are found in the free excerpt. Good luck!

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.

Digg This!

StumbleUpon

Del.icio.us

RELATED CONTENT

	NetServer
	Displaying an image from the AS/400 on a PC, troubleshooting
	Lock within NetServer
	How does one setup NetServer?
	NetServer fails to start properly
	Error message when Netserver starts
	Connecting to the NetServer from Windows 2000
	ISeries 400 NetServer
	User profile disabled on NetServer
	The 400/Windows connection
	A security problem with NetServer

iSeries Access (Client Access)

Modern System i reports using Client Access

Automate Client Access to find files on Windows scheduler

Saving multiple sessions on IBM iSeries Client Access when using Vista

Running a job on the iSeries after it has been transferred to a PC

SQL7008 error in iSeries Access and journals

Converting and transferring AS/400 packed decimal fields to ASCII systems

Copying the spool file stream to IFS

How to: Transfer unlimited data to Excel from AS/400

Microsoft computing: Integrating the iSeries and Microsoft Office

i5/OS and Microsoft Office Integration Handbook, Third Edition -- Chapter 3

Physical connections to iSeries

Configure the iSeries v5r4 to open the HTTPS port for incoming connections

"Time" saving programming tips for iSeries

PC/Windows connectivity: Top 10 expert Q&As

Run command on a PC

Working with ODBC and dates

Why is my job taking twice as long?

Problems with new server and PC

Take control of your iSeries network security -- Part 2

Microsoft computing: Integrating the iSeries and Microsoft Office

i5/OS and Microsoft Office Integration Handbook, Third Edition -- Chapter 3

Physical connections to iSeries Research

RELATED RESOURCES

2020software.com, trial software downloads for accounting software, ERP software, CRM software and business software systems

Search Bitpipe.com for the latest white papers and business webcasts

Whatis.com, the online computer dictionary

iSeries AS/400 Solutions: Grid Computing

SEARCH

TechTarget provides technology professionals with the information they need to perform their jobs - from developing strategy, to making cost-effective purchase decisions and managing their organizations' technology projects - with its network of technology-specific websites, events and online magazines.


TechTarget Corporate Web Site \| Media Kits \| Site Map All Rights Reserved, Copyright 1999 - 2009, TechTarget \| Read our Privacy Policy