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.

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.

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.

Figure 3

5. Click "Next" to filter data. (In this example, no filtering operation is performed), as shown in figure 4.

Figure 4

6. Click "Next" to confirm the keyword. (No keyword is selected in this example), as shown in Figure 5.

Figure 5

7. Click "Next" to go to the screen shown in Figure 6 and select "return data to Microsoft Excel (R )".

Figure 6

8. Click "finish" to collect data to Microsoft Excel, as shown in 7.

Figure 7

Related Articles]

• How to read Excel Data and import it to the DB2 database

• Use AWK to synchronize DB2 database Schema

• How to Develop SQL-XQuery Web Service converter for DB2 9