.DBF Table Created in MSQUERY not Recognized in dBASE III/III+

ID: Q121523

1.00 2.00 WINDOWS kbtool kb3rdparty

The information in this article applies to:

• Microsoft Query for Windows, version 1.0
• Microsoft Query for Windows 95, version 2.0

SYMPTOMS

In Microsoft Query, when you save a query as a dBASE III table, you are unable to open the table file in dBASE III or dBASE III+ if the file contains more than 128 fields. The applications do not recognize the table as a dBASE file.

CAUSE

This behavior occurs because Microsoft Query is able to handle a dBASE table that contains more than 128 fields. When you create a query using the dBASE III data source, you can add a table, and add all of the fields from the table, even if the table contains more that 128 fields.

However, if you save a query that contains more than 128 fields as a dBASE III table in Microsoft Query, you cannot use the table in dBASE III or dBASE III+.

WORKAROUND

To work around this behavior, make sure that your query contains less than 128 fields before you save the query as a dBASE III table.

STATUS

Microsoft has confirmed this to be a problem in the Microsoft products listed at the beginning of this article. We are researching this problem and will post new information here in the Microsoft Knowledge Base as it becomes available.

MORE INFORMATION

For additional information, please see the following article(s) in the Microsoft Knowledge Base:

   ARTICLE-ID: Q110601
   TITLE:    : Microsoft Query: dBASE Files and Field Limits

   ARTICLE-ID: Q104441
   TITLE     : Excel: Fields Truncated When File Is Saved in .DBF Format

REFERENCES

For more information about the Save As Command (File Menu), choose the Search button in Help and type:

   saving data

Additional reference words: 1.00 2.00 5.00 5.00c 3+

Keywords          : xlquery 
Version           : 1.00 2.00
Platform          : WINDOWS

Last Reviewed: September 15, 1996