Microsoft KB Archive/119252

= Microsoft Knowledge Base =

MSQuery: No Data Returned If Sheet Name Contains Comma
Last reviewed: January 21, 1997

Article ID: Q119252

The information in this article applies to:


 * Microsoft Query for Windows, version 1.0
 * Microsoft Excel for Windows, versions 5.0, 5.0c
 * Microsoft Excel for the Macintosh, version 5.0
 * Microsoft Query for Windows 95, version 2.0
 * Microsoft Excel for Windows 95, versions 7.0, 7.0a

SYMPTOMS
When you access Microsoft Query version Microsoft Excel, and you attempt to return data to a worksheet where the sheet name contains a comma, data will not be returned.

NOTE: You will not receive an error message when this happens.

WORKAROUND
To work around this behavior, remove the comma from the sheet name and run the query again.

STATUS
Microsoft has confirmed this to be a problem in the versions of Microsoft Query listed above. We are researching this problem and will post new information here in the Microsoft Knowledge Base as it becomes available.