How to Export Data from Word for Windows to "PowerLeads!"

Last reviewed: February 5, 1998
Article ID: Q117697
2.00 2.00a 2.00a-CD 2.00b 2.00c 6.00 6.00a 6.00c WINDOWS
 

The information in this article applies to:
  • Microsoft Word for Windows, versions 2.0, 2.0a, 2.0a-cd, 2.0b, 2.0c, 6.0, 6.0a

SUMMARY

This article describes how to export data from a Microsoft Word data file to "PowerLeads!".

MORE INFORMATION

To export information from a Word for Windows table to PowerLeads!, you must save your information as an ASCII text file. If your data file is set up in a table format, you must first convert the table to text.

  1. In Word, select the table.

  2. From the Table menu, select Convert Table To Text.

  3. Word 2.x for Windows: In the Separate Text With box, select Commas and choose OK.

    Because the fields are now separated by a comma, followed by a space, you must strip out the spaces, or these will be converted as part of the fields. (Note: This extra space does not affect merge results when both the main document and data file are Word documents.) From the Edit menu, choose Replace and replace both the comma and space with a comma.

    Word 6.0 for Windows: In the Separate Text With box, select Other and use a comma to eliminate the extra space. This will eliminate the need to Edit/Replace the comma and space.

  4. Save the document as a text file.

  5. Open PowerLeads! and create a new database.

  6. From the Database menu, choose Import.

  7. In the Import dialog box, select ASCII and choose OK.

  8. In the Open Import File dialog box, select your file.

  9. Match the fields for your import data to the PowerLeads! fields, "Add" these fields to your database, and choose the Completed button when finished.

  10. When PowerLeads! prompts you with, "OK to skip duplicate entries?", choose the Yes button.

When finished, PowerLeads! will generate the message "Import process completed. Please review and update your new records."

PowerLeads!, manufactured by Pyramid Data Inc., is a relational database for contact management systems for the Windows environment. Pyramid Data can be contacted at:

   Pyramid Data Inc.
   1660 S. Amphlett Blvd, Suite 305
   San Mateo, CA 94402
   (415) 312-7070 or (800) 972-PYRAMID

The PowerLeads! product included here is manufactured by a vendor independent of Microsoft; we make no warranty, implied or otherwise, regarding this product's performance or reliability.


KBCategory:
KBSubcategory: kbmerge
Additional reference words: winword2 6.00 6.00a 2.00 2.00a 2.00a-CD 2.00b
word6 2.00c
powerleads export ascii comma space datafile data file data source
mail merge print merge winword

Keywords : kbmerge kbprint
Version : 2.00 2.00a 2.00a-CD 2.00b 2.00c
Platform : WINDOWS
Issue type : kbhowto


THE INFORMATION PROVIDED IN THE MICROSOFT KNOWLEDGE BASE IS PROVIDED "AS IS" WITHOUT WARRANTY OF ANY KIND. MICROSOFT DISCLAIMS ALL WARRANTIES, EITHER EXPRESS OR IMPLIED, INCLUDING THE WARRANTIES OF MERCHANTABILITY AND FITNESS FOR A PARTICULAR PURPOSE. IN NO EVENT SHALL MICROSOFT CORPORATION OR ITS SUPPLIERS BE LIABLE FOR ANY DAMAGES WHATSOEVER INCLUDING DIRECT, INDIRECT, INCIDENTAL, CONSEQUENTIAL, LOSS OF BUSINESS PROFITS OR SPECIAL DAMAGES, EVEN IF MICROSOFT CORPORATION OR ITS SUPPLIERS HAVE BEEN ADVISED OF THE POSSIBILITY OF SUCH DAMAGES. SOME STATES DO NOT ALLOW THE EXCLUSION OR LIMITATION OF LIABILITY FOR CONSEQUENTIAL OR INCIDENTAL DAMAGES SO THE FOREGOING LIMITATION MAY NOT APPLY.

Last reviewed: February 5, 1998
© 1998 Microsoft Corporation. All rights reserved. Terms of Use.