Microsoft KB Archive/121523

= .DBF Table Created in MSQUERY Not Recognized in dBASE III/III+ =

Article ID: 121523

Article Last Modified on 8/15/2005

-

APPLIES TO


 * Microsoft Excel 95 Standard Edition
 * Microsoft Excel 5.0 Standard Edition
 * Microsoft Query 2000

-



This article was previously published under Q121523



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:

110601 Microsoft Query: dBASE Files and Field Limits

104441 Excel: Fields Truncated When File Is Saved in .DBF Format

dBASE III is manufactured by Borland International, Inc., a vendor independent of Microsoft; we make no warranty, implied or otherwise, regarding this product's performance or reliability.

