ACC: How to Use Q+E to View SQL Server Tables

ID: Q105517

The information in this article applies to:
  • Microsoft Access versions 1.0, 1.1, 2.0, 7.0
  • Microsoft Excel for Windows, versions 3.0, 4.0

SUMMARY

Advanced: Requires expert coding, interoperability, and multiuser skills.

This article describes how to use the release of Q+E that is included with Microsoft Excel versions 3.0 and 4.0 to view data from the sample Pubs database that is supplied with Microsoft SQL Server.

You can use Q+E to troubleshoot ODBC problems with connecting to SQL Server data sources. Because Q+E does not use ODBC to connect to SQL Server, it can be used to help diagnose connection problems.

If you are unable to connect to a SQL Server data source using either ODBC or Q+E, there may be a problem with the network (NETAPI.DLL) or with the server itself.


MORE INFORMATION

Q+E is a database application that you can use to manipulate and update database files from a variety of database systems, including Microsoft SQL Server. An abbreviated version of Q+E is included with Microsoft Excel versions 3.0 and 4.0.

The following example demonstrates how to view the contents of the Authors table in the sample Pubs database that is supplied with SQL Server:

  1. Start Q+E and click Logon on the File menu.


  2. In the Sources list, select SQL Server, and then click OK.


  3. In the Server Name box, type the name of the server that contains the tables you want to use.


  4. In the Login ID box, type your SQL Server login name.

    NOTE: The system administrator is typically "sa."


  5. In the Password box, type the password for the user entered in the Login ID box.


  6. Click OK.


  7. On the File menu, click Open.


  8. In the Owner List box, select Pubs, and then click OK.


  9. In the Table List box, select Authors, and then click OK. Note that the Authors table is displayed in a window similar to the Microsoft Access Datasheet view.


Q+E is manufactured by Pioneer Software Systems, a vendor independent of Microsoft; we make no warranty, implied or otherwise, regarding this product's performance or reliability.


REFERENCES

Microsoft Excel "Q+E for Microsoft Excel User's Guide," version 3.0, Appendix C

Microsoft Excel "Q+E for Microsoft Excel User's Guide," version 4.0, Appendix D

Additional query words: kbinterop

Keywords : kb3rdparty kbinterop IsmExl4
Version : WINDOWS:1.0,1.1,2.0,3.0,4.0,7.0
Platform : WINDOWS
Issue type : kbhowto


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