Microsoft KB Archive/191113

= XL98: Fields Truncated When File Is Saved in dBASE Format =

Article ID: 191113

Article Last Modified on 9/11/2002

-

APPLIES TO


 * Microsoft Excel 98 for Macintosh

-



This article was previously published under Q191113





SYMPTOMS
If a Microsoft Excel 98 Macintosh worksheet contains a table with more than 32 columns and you save the file in a dBASE file format, you may only save the first 32 columns of the database. When you close and reopen the file, the columns after the 32nd column may be missing.



CAUSE
This situation occurs because the dBASE file formats will only support a maximum of 255 fields per record in DBF 4 (dBASE IV), 128 fields per record in DBF 3 (dBASE III), and 32 fields per record in DBF 2 (dBASE II).



STATUS
This is by design of Microsoft Excel 98 Macintosh Edition.

Additional query words: XL98

Keywords: kbprb KB191113

-

[mailto:TECHNET@MICROSOFT.COM Send feedback to Microsoft]

© Microsoft Corporation. All rights reserved.