Q+E: Error Accessing SQLServer Fields Containing a Space

Last reviewed: November 3, 1994
Article ID: Q78759

Summary:

If you try to place a space in a text field or leave it blank in Q+E, the following error message is generated

   The column "your_field" in table "your_table" may not be null.

where your_field and your_table refer to the specific names of the table and field on which you are working.

The field can contain a space; however, Q+E treats such an entry as a null, which it cannot query on in an SQLServer.

Microsoft has confirmed this to be a problem in Q+E version 3.0. We are researching this problem and will post new information here as it becomes available.

More Information:

To insert a space into a text field in Q+E, use a query such as the following:

   Insert into MY_TABLE VALUES (" ")

This inserts a new record into a table called MY_TABLE. The first field will have a space in it. To enter this query, choose Open from the File menu, and select the SQL button. An SQL Query dialog box will appear, in which you can enter this command.

Reference(s):

"Q+E for Microsoft Excel User's Guide," version 3.0, page 33-36

KBCategory: kbother
KBSubcategory:
Additional reference words: 3.00 3.0

THE INFORMATION PROVIDED IN THE MICROSOFT KNOWLEDGE BASE IS PROVIDED "AS IS" WITHOUT WARRANTY OF ANY KIND. MICROSOFT DISCLAIMS ALL WARRANTIES, EITHER EXPRESS OR IMPLIED, INCLUDING THE WARRANTIES OF MERCHANTABILITY AND FITNESS FOR A PARTICULAR PURPOSE. IN NO EVENT SHALL MICROSOFT CORPORATION OR ITS SUPPLIERS BE LIABLE FOR ANY DAMAGES WHATSOEVER INCLUDING DIRECT, INDIRECT, INCIDENTAL, CONSEQUENTIAL, LOSS OF BUSINESS PROFITS OR SPECIAL DAMAGES, EVEN IF MICROSOFT CORPORATION OR ITS SUPPLIERS HAVE BEEN ADVISED OF THE POSSIBILITY OF SUCH DAMAGES. SOME STATES DO NOT ALLOW THE EXCLUSION OR LIMITATION OF LIABILITY FOR CONSEQUENTIAL OR INCIDENTAL DAMAGES SO THE FOREGOING LIMITATION MAY NOT APPLY.

Last reviewed: November 3, 1994
© 1998 Microsoft Corporation. All rights reserved. Terms of Use.