KB179946 - OL98: How to Import Information from Goldmine

Article ID: 179946

Article Last Modified on 10/21/2000

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

With the Goldmine database open, on the Tools menu, click Export Records.
Click to select DBF File as the Data Format and click Next.
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.
Click Finish. Goldmine reports how many records were exported and the elapsed time. Click OK.

Open the dbf file in Microsoft Excel

Open the dbf file in Excel.
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.
Save the file in Comma Separated Value format, and exit Excel.

Import File Into Outlook

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

REFERENCES

For more information about Importing files into Outlook, type "Import dBase" in the Office Assistant, click Search, and then click to view "Import information into Outlook"

Goldmine is manufactured by Goldmine Software Inc., a vendor independent of Microsoft; we make no warranty, implied or otherwise, regarding this product's performance or reliability.

Keywords: kbhowto kb3rdparty KB179946