Microsoft KB Archive/179946

= OL98: How to Import Information from Goldmine =

Article ID: 179946

Article Last Modified on 10/21/2000

-

APPLIES TO


 * Microsoft Outlook 98 Standard Edition

-



This article was previously published under Q179946





SUMMARY
This article describes how to export contacts from Goldmine and import them into Microsoft Outlook 98.



MORE INFORMATION
To import Goldmine information into Outlook, you must export from Goldmine in dbf format to Microsoft Excel, correct the field names, and then import the file into Outlook. Even though Outlook can import a dbf file, you will need to modify the field names to match those in Outlook. This can be done with Microsoft Excel.

For additional information on what the field names need to be for import into Outlook, click the article number below to view the article in the Microsoft Knowledge Base:

185361 OL98: Internal Fields Used by Outlook Folders

For additional information on Field mapping for Outlook, click the article number below to view the article in the Microsoft Knowledge Base:

182728 OL98: Options For Custom Field Mapping When Importing Items

Export the Goldmine File

 * 1) With the Goldmine database open, on the Tools menu, click Export Records.
 * 2) Click to select DBF File as the Data Format and click Next.
 * 3) Under Get Filename, type the path and file name you want, or click Browse and select the export location you want, for example: C:\my documents\mydata.dbf Click Next twice.
 * 4) Click Finish. Goldmine reports how many records were exported and the elapsed time. Click OK.

Open the dbf file in Microsoft Excel

 * 1) Open the dbf file in Excel.
 * 2) Using the article 185361 as a reference modify the field names in the header row of the file to correspond to the appropriate Outlook fields.
 * 3) Save the file in Comma Separated Value format, and exit Excel.

Import File Into Outlook

 * 1) On the File menu, click Import and Export.
 * 2) Click "Import from another Program or file," and click Next.
 * 3) Click to select Comma Separated Value (Windows) and click Next.
 * 4) Enter the path to the file to import and click Next.
 * 5) Click to select the folder to import the file into, such as Contacts. Click Next, and then Finish.

