Microsoft KB Archive/105517

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

Article ID: 105517

Article Last Modified on 1/26/2005

-

APPLIES TO


 * Microsoft Access 1.0 Standard Edition
 * Microsoft Access 1.1 Standard Edition
 * Microsoft Access 2.0 Standard Edition
 * Microsoft Access 95 Standard Edition
 * Microsoft Excel 3.0 Standard Edition
 * Microsoft Excel 4.0 Standard Edition

-



This article was previously published under Q105517



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."
 * 1) In the Password box, type the password for the user entered in the Login ID box.
 * 2) Click OK.
 * 3) On the File menu, click Open.
 * 4) In the Owner List box, select Pubs, and then click OK.
 * 5) 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.

