Microsoft KB Archive/239188

= Works 6/2000: Cannot Merge Database That Contains Formulas with a Publisher 2000 Publication =

Article ID: 239188

Article Last Modified on 1/25/2007

-

APPLIES TO


 * Microsoft Works 2000 Standard Edition
 * Microsoft Works 6.0
 * Microsoft Publisher 2000 Standard Edition

-



This article was previously published under Q239188



SYMPTOMS
When you attempt to merge a Microsoft Works 2000 database or Microsoft Works 6 database with a Microsoft Publisher 2000 publication, you may receive the following error message:

Publisher cannot import a Works database that includes formulas.



CAUSE
This behavior can occur if any of the fields in the database contains a formula.



RESOLUTION
To work around this issue, make a copy of the Works database, remove the formulas from the copy of the database, and then merge the modified database with the Publisher 2000 publication:
 * 1) Open the Works database that you want to merge with the Publisher 2000 publication.
 * 2) On the File menu, click Save As.
 * 3) In the File name box, type a new name for the database.
 * 4) In the Save in box, click the folder in which you want to save the database, and then click Save.
 * 5) Click the name of the field that contains a formula to select the entire field.
 * 6) On the Record menu, click Delete Field.
 * 7) When you are prompted to confirm the deletion, click OK.
 * 8) Repeat steps 5 through 7 for each field that contains a formula.
 * 9) Merge the modified Works database with the Publisher 2000 publication.

Additional query words: w_works pub2k works2k works6 w2001 wksdb imports mspub

Keywords: kberrmsg kbinterop kbprb KB239188

-

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

© Microsoft Corporation. All rights reserved.