MSQUERY: Available Data Sources List Empty

ID: Q132975

2.00 WINDOWS kbtool xlquery

The information in this article applies to:

• Microsoft Query for Windows 95, version 2.0

SYMPTOMS

In Microsoft Query, when you click the New Query button or click New Query on the File menu, the Available Data Sources list in the Select Data Source dialog box may be empty.

CAUSE

This behavior occurs after you install Microsoft Query, using either the Microsoft Office version 7.0 Setup program or the Microsoft Excel version 7.0 Setup program. This behavior is by design of Microsoft Query. The list of data sources that Microsoft Query uses is different from the list of data sources that ODBC uses.

To view the list of data sources that ODBC uses, do the following:

1. In Microsoft Query, click New Query on the File menu.

2. In the Select Data Source dialog box, click Other.

The ODBC Data Sources dialog box displays the list of data sources that you can use in Microsoft Query.

RESOLUTION

To add a data source to the Available Data Sources list in Microsoft Query, do the following:

1. In Microsoft Query, click New Query on the File menu.

2. In the Select Data Source dialog box, click Other.

3. In the ODBC Data Sources dialog box, click the data source that you

   want to use. (Or click New to add a new data source.)

The selected data source now appears in the Available Data Sources list in Microsoft Query.

REFERENCES

For more information about adding a data source in Microsoft Query, click the Index tab in Microsoft Query Help, type the following text

   adding data

KBCategory: kbtool KBSubcategory: xlquery

Additional reference words: 2.00

Keywords          : xlquery 
Version           : 2.00
Platform          : WINDOWS

Last Reviewed: September 15, 1996