Microsoft KB Archive/79484

= Works: Fields in dBASE Files Are Padded with Spaces =

Article ID: 79484

Article Last Modified on 11/16/2006

-

APPLIES TO


 * Microsoft Works 2.0 Standard Edition
 * Microsoft Windows 3.0 Standard Edition
 * Microsoft Windows 3.1 Standard Edition

-



This article was previously published under Q79484



SYMPTOMS
When you open a dBASE file in the Works for Windows Database module, all of the field entries are padded with spaces. This creates problems when you try to query, print labels, or print form letters.



STATUS
Microsoft has confirmed this to be a problem with Works 2.0 for Windows. This problem was corrected in Works 2.0a for Windows.



WORKAROUND
Below is a temporary solution that will work around the problem until you can get a copy of Works for Windows 2.0a.

Do the following to remove the extra spaces in the fields:

 Open the dBASE file into Works for Windows Database. From the File menu, choose Save As.

 Enter a temporary filename (eight-character maximum). Select Text & Commas from the Save File As list. Choose the OK button to save the file. </li> From the File menu, choose Close.</li> From the File menu, choose Open Existing File.

 Type the name of the file just saved.</li> Choose the OK button.</li> In the Open File As dialog box, select Word Processor.</li> From the Select menu, choose Replace.</li> In the Find What text box, type ^W&quot; .</li> In the Replace With text box, type &quot; .</li> Choose the Replace All button.</li></ol> </li> From the File menu, choose Save.</li> From the File menu, choose Close.</li> From the File menu, choose Open Existing File.</li> Type the name of the file just saved in Word Processor.

 Choose the OK button.</li> <li>In the Open File As dialog box, select Database.</li></ol> </li> <li>From the File menu, choose Save As.

<ol style="list-style-type: lower-alpha;"> <li>Type a new filename (eight-character maximum).</li> <li>Select Works DB in the Save File As Type list.</li> <li>Choose the OK button.</li></ol> </li></ol>

Additional query words: 2.00a dBase fixed length fields file based d base export db trailing

Keywords: KB79484

-

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

© Microsoft Corporation. All rights reserved.