Microsoft KB Archive/155082

= PUB97: How to Import a Works 95 Database as a Data Source for Mail Merge =

Article ID: 155082

Article Last Modified on 10/8/2003

-

APPLIES TO


 * Microsoft Publisher 97 Standard Edition, when used with:
 * Microsoft Windows NT 4.0

-



This article was previously published under Q155082



SYMPTOMS
If you try to use a database created in Microsoft Works as the data source for a mail merge in Publisher 97, you may receive the following error message:

Publisher cannot import a database that includes formulas.



CAUSE
This will occur if you created your Works database using the TaskWizard.

By default, when you use the TaskWizard to create a database, it inserts a field called TDate. This field contains a formula. Depending on what type of database you create, there may be other fields that contain formulas as well. Publisher can't use a database that contains formulas as a source for a mail merge.



RESOLUTION
To work around this problem, use any of the following methods.

Method 1: Remove the formulas from the database
 Start Works and open the database (.wdb) file. On the File menu, click Save As. Save the database file with a different name. On the View menu, click List.

This will display your database in table form, with the fields listed across the top of the screen, and each row representing one record. Identify which fields contain formulas by doing the following:   Click the cell that represents the first field of the first record. Look at the formula bar at the top of the screen. If the data in the formula bar starts with an equal sign, that field contains a formula. By default, the field called Tdate will contain the formula =NOW  Click the cell representing the second field of the first record. Look at the formula bar to see if this field contains a formula.</li> Repeat this process for the rest of the fields.</li></ol> </li> When you locate a fields that contain a formula, remove the formula. To remove a formula: <ol style="list-style-type: lower-alpha;"> Click the field name at the top of the screen to select it.</li> On the Format menu, click Protection.</li> Make sure there is no mark in the Protect Field box. Click OK.</li> On the Edit menu, click Clear Formula.</li></ol> </li> After you have cleared all the formula, click Save on the File menu.</li></ol>

You now have a copy of the database; use this copy as a data source for the Publisher Mail Merge.

NOTE: Be sure to use this copy instead of the original file.

Method 2: Save the database as a text file
<ol> Start Works and open the database (.wdb) file.</li> On the File menu, click Save As.</li> In the Save File as Type list, click Text & Tabs.</li> Type a file name in the File Name box. Click OK.

You can use this text file as a data source for a Publisher Mail Merge. When you open this data source in Publisher, Publisher will ask:

Do you want to use the entries in the first row of your data as field names?

Click No. If you click Yes, you may receive the following error:

Microsoft Publisher cannot import your data source because it contains more than one field with the same name. Please rename any duplicate fields and try again.

</li></ol>

<div class="status_section">

STATUS
Microsoft is researching this problem and will post new information here in the Microsoft Knowledge Base as it becomes available.

Additional query words: 97 4.0 pub97 w_mspub winworks mspub pub4

Keywords: kberrmsg kbinterop kbprb KB155082

-

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

© Microsoft Corporation. All rights reserved.