Microsoft Excel uses ODBC to easily obtain DB2 data

Microsoft Excel is a frequently used tabulation tool. It can use ODBC to conveniently obtain DB2 data on AS/400. The procedure is as follows: (the procedure is described in the WIN2000 + Office2000 environment. you have configured the ODBC Data Source)

1. Open Microsoft Excel and create a new table.

2. Choose DATA> obtain external data> create database query, as shown in figure 1.

3. Select the created ODBC Data Source (such as as400db2) and press "OK". Enter the user name and password, and the "query wizard" screen is displayed, as shown in figure 2.

4. In Figure 2, select the physical file you want to query and select the required fields to "columns in the query results", as shown in figure 3.

1 2 Next Page

[Content navigation]
Page 1st: Microsoft Excel allows you to easily obtain DB2 data with ODBC	Page 2nd: Microsoft Excel allows you to easily obtain DB2 data with ODBC