OL98: How to Import Information from Goldmine (179946)

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: For additional information on Field mapping for Outlook, click the article number below to view the article in the Microsoft Knowledge Base:

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.