Add Your Tables

From the Add Tables dialog box, click the name of the table you want to add (for example, PETS) and then click Add. Do this for each table you want to add. Close the dialog box when you're finished. For each table you selected, a list box is displayed on the Microsoft Query screen. This list box shows all of the columns in the associated table.

In a list box, double-click each column that you want to read into your Excel spreadsheet. If you want to add all columns, double-click the "*" at the top of the list box. If you prefer, you can select columns or further refine your query by clicking the SQL button on the toolbar and typing your own SQL statements. See SQL Commands for a description of the SQL commands supported by Micro Focus XDBC.

Click OK when you're finished.

In the Microsoft Query dialog box, click File > Return Data to Microsoft Excel. The Import Data dialog box appears.

Select where to put the data and then click OK. If you want to select further options, click Properties. If no database security methods have been established, the Micro Focus XDBC Login dialog box will not appear. If database security methods have been established and you previously supplied a correct user ID and password, this step will not be necessary. However, if database security measures were established and you have not entered a valid user ID or password, you will be prompted to do so at this time.

You are returned to Excel. The data you selected is displayed in the current Excel spreadsheet.