search for books and compare prices
Tables of Contents for The Os/400 & Microsoft Office Integration Handbook
Chapter/Section Title
Page #
Page Count
Introduction
xiii
Combining capabilities
xiv
About This Book
xiv
Following Along with the Sample Data
xv
Client Access Overview
1
10
Client Access 95/NT And Client Access Express Components
2
4
Client Access Express Licenses
6
1
Installing Microsoft Office Integration
7
1
Configuring A Connection
8
3
ODBC
11
24
What Is ODBC?
11
1
Architecture
12
2
Configuring a Client Access Express ODBC DSN
14
8
Create the AS/400 Directory Entry
14
2
Create a Data Source
16
6
ODBC Security
22
4
Security and Data Updates
22
2
Password ``Sniffing'' Using Trace
24
2
Why Use ODBC?
26
1
ODBC Tips and Techniques
27
6
Automating DSN Setup
27
3
Accessing Multimember Database Files
30
2
Making Data Updateable through ODBC
32
1
Summary
33
2
Retrieving DB2/400 Data with MS Query
35
24
Coming to Terms
36
1
Installation
36
2
Installing Microsoft Query
38
1
Creating a Shortcut
39
1
A Quick Lesson
40
2
Creating a Simple Query Using the Wizard
42
3
Creating a Query without the Wizard
45
1
Saving the Query
46
1
Sorting Records
47
1
Updating Data
48
1
Speeding Up the Design Process
49
1
Filtering Records
50
2
Joining Tables
52
4
Totaling and Grouping
56
2
Performance Cautions
58
1
Summary
58
1
Using AS/400 Data with Ms Word
59
32
Using ODBC Or OLE DB/ADO To Retrieve AS/400 Data
60
1
Creating Mailing Labels with ODBC
60
10
Create
62
1
Get Data
62
7
Merge
69
1
Creating form Letters
70
4
Create
70
1
Get Data
70
3
Merge
73
1
Creating Addressed Envelopes
74
4
Create
74
1
Get Data
74
3
Merge
77
1
Inserting Data into a Table
78
3
Moving AS/400 Data into Word with OLE DB/ADO
81
8
OLE DB/ADO Dynamic Connection
81
1
Using OLE DB/ADO with Word
82
1
Creating a Word Macro
83
2
OLE DB/ADO Macro for Word
85
4
Summary
89
2
Analyzing DB2/400 Data with Excel
91
56
Retrieving Data in A List with Microsoft Query
91
7
Creating a Chart from AS/400 Data
98
8
Preparing the Data
98
2
Creating Charts
100
6
Creating a Pivot table
106
9
Pivot table, Step 1
106
1
PivotTable, Step 2
107
3
PivotTable, Step 3
110
2
PivotTable, Step 4
112
3
The Client Access Express Excel Add-In
115
7
Installing the Client Access Express Excel Add-In
115
2
Using the Client Access Express Excel Add-In
117
5
Accessing DB2/400 Data with a VBA Macro
122
1
Accessing DB2/400 Data with ODBC
123
2
Accessing DB2/400 Data with OLE DB
125
2
Importing DB2/400 Data without Client Access
127
6
Create and Run a Data Extract on the AS/400
128
1
Import the Data into Excel
129
4
Easy Download Utility
133
7
OLE DB Vs. ODBC
134
1
Standard Requirements for the Utility
135
1
Before You Run the Spreadsheet
136
1
Putting the Utility to Use
136
1
Entering the Code Yourself
137
1
Examining the Code
137
2
Take It from Here
139
1
Updating AS/400 Data
140
5
What Makes Your Program So Different?
140
1
What Are the Prerequisites?
140
3
How Does It Work?
143
1
The Code Behind the Scenes
144
1
Surgeon General's Warning
145
1
Up, Up, Upload Away!
145
1
Summary
145
2
Expanding Your Options with Access
147
98
Terminology
147
1
Using AS/400 Data
148
9
What Is Linking?
148
7
Linking. Step by Step
155
1
What Is Importing?
155
1
Importing Step by Step
156
1
Linking vs. Importing
157
1
Deleting Tables
157
1
The Datasheet View
157
3
Access Queries
160
30
Select Queries
160
4
Viewing Queries within Access
164
2
Shorting and Filtering Data
166
6
Joining Tables
172
9
Summary Queries
181
2
Parameter Queries
183
3
Join Types
186
1
Action Queries
187
1
Update Query
188
2
Performance Cautions
190
1
Access Forms
190
17
Form Types
191
1
Creating a Form
191
4
Customizing Forms
195
6
Tabular AutoForms
201
1
Creating Graphs with AS/400 Data
202
5
Access Reports
207
23
Creating a Report
208
5
The Report Editor
213
2
Grouping and Totaling
215
10
Mailing Labels
225
5
Exporting Data
230
6
Export Limitations
235
1
Speed Tips
236
7
Pass-through Queries
237
4
Pass-through Query Limitations
241
1
Off-loading processing
242
1
Limiting Library Searching
242
1
Security with Access, ODBC, and AS/400 Data
243
1
Summary
244
1
Retrieving Email with Outlook
245
26
Background
245
2
Setting up the AS/400 as a Mail Server
247
10
Setting up OS/400's Email Servers from a 5250 Terminal
247
10
Configuring OS/400 Email with Operations Navigator
257
6
Configuring SMTP
258
2
Configuring POP3
260
2
Setting Up Mail Users with Ops Nav
262
1
Configuring Your Email Clients
263
6
Reading Your Email
267
2
Summary
269
2
The AS/400 in the Network Neighborhood
271
20
Client vs. Server Emulation
271
1
Client Access 95/NT Network Drives
272
1
OS/400's Netserver
273
1
Network Neighborhood Capabilities
274
2
Configuration and Usage
276
4
Using the Network-Drive Function
280
1
Understanding the Directories
281
5
Creating a Send to Notepad Option
286
1
Mapping a PC Drive to the AS/400
287
1
What about Security
288
2
Summary
290
1
The Client Access Express Data-Transfer Function
291
26
Background
292
1
PC File Formats
292
2
Transferring Data from an AS/400 to Your PC
294
9
Transferring Data from a PC to an AS/400
303
5
The Create Database File Wizard
308
2
Automating with Batch Files
310
2
Why Does My Data Look Like Garbage?
312
3
Curing CCSID Problems with V3R1M3 and Higher
313
1
Curing CCSID Problems with V3R1M2 and Earlier Versions
314
1
Summary
315
2
Transferring Data with FTP
317
14
What is FTP?
317
3
FTP Pros
318
1
FTP Cons
319
1
FTP Basics
319
1
FTP Security
320
1
FTP on the AS/400
321
1
Transferring Files with FTP
322
3
FTP Commands
325
1
File Listing Formats
325
4
Changing the FTP Server Default Name Format
327
1
Handling FTP Clients
327
2
To FTP or not to FTP?
329
2
Microsofts OLE DB/ADO Technology
331
10
Microsoft Universal Data Access
331
5
OLE DB and ADO
332
1
ActiveX Data Object (ADO)
332
1
The Two Parts of OLE DB/ADO
332
1
The AS/400 Data Access Provider
333
1
Acquiring and Installing Microsoft OLE DB/ADO Support
333
1
The ADO Object Model
334
1
Using OLE DB/ADO
335
1
OLE DB/ADO Programming Examples with Visual Basic
336
5
Using OLE DB/ADO with an ODBC Data Source
338
2
Performance Considerations When Using ODBC with ADO
340
1
Appendix: Support and Troubleshooting
341
4
Web Resources
341
4
Index
345