MSQUERY: Available Data Sources List Empty

ID: Q132975


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.)


  4. Click OK.


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
double-click the selected text, and then double-click "Add Data Sources for Installed Drivers" to go to the "Add Data Sources for Installed Drivers" topic.

Additional query words:

Keywords : xlquery
Version : WINDOWS:2.0
Platform : WINDOWS
Issue type :


Last Reviewed: October 6, 1999
© 2000 Microsoft Corporation. All rights reserved. Terms of Use.