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

• Microsoft Access versions 1.0, 1.1, 2.0, 7.0
• Microsoft Excel 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.

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