Article ID: 182728 - View products that this article applies to.
This article was previously published under Q182728
This article has been archived. It is offered "as is" and will no longer be updated.
You are importing data using the Import/Export feature of Microsoft Outlook 98. You want to map fields from your data source into the equivalent field in Outlook. The feature to allow field mapping is not available. This article describes techniques you may use to successfully import data into Outlook.
The custom field mapping feature that was included in Outlook 97 is not included in Outlook 98 due to problems with the conversion technology. The field mapping functionality is licensed from DataViz, Inc. and, in its current state, is no longer available to Microsoft for use in Outlook 98.
Microsoft now provides an Importer Field Mapping Patch for Outlook 98 that includes the field mapping functionality previously found in Outlook 97.
To successfully map fields from personal information manager files or other data sources, you have two options. The first and preferred option is to download and install the Importer Field Mapping Patch for Outlook 98 from the Microsoft Office Update Web site. The second and less preferred option is to manually match the original fields to the internal name that Outlook uses for the fields.
This article outlines the circumstances pertinent to the field mapping issue and offers suggestions for successfully importing data to Outlook. The following topics are discussed:
Importer Field Mapping Patch for Outlook 98The easiest way to import data using the Import/Export feature of Outlook 98, and map fields from your data source, such as a spreadsheet or database file, into the equivalent fields in Outlook is by downloading and installing the Importer Field Mapping Patch for Outlook 98. The patch is available at the following Internet address:
http://office.microsoft.com/downloads/9798/field98.aspxAfter installing the patch:
Manual Field MappingOutlook items use specific field names to organize the data. When you import information to an Outlook folder, the field names from the source file must exactly match those in the Outlook target item. If these fields do not match, the fields that you expect to be populated with data will be blank. Mapping of data from various sources requires you to inspect and, if necessary, manually edit the field names. In addition, there must be a header row that defines the information in each column. This is different from Outlook 97, which gives you the option to map fields without a header row.
In order to manually map fields when doing an import from Comma Separated Values (CSV) and Tab Separated Values (TSV) files, the field values in the header record must be edited to exactly match the corresponding Outlook field. The header record of a data file is the first line of the file, and contains the field names of the data to be imported. For example, a field name, "F_Name" in a data source may refer to individual first names. Such a field name would be changed for mapping in Outlook import to "First Name," since Outlook uses First Name for its internal naming of that field. For information on generating samples of Outlook field labels, see the section, "Generating a Sample of Outlook Fields."
Additionally, data files created by Microsoft programs such as Microsoft Excel, Microsoft Word, Microsoft Access and Microsoft Fox Pro will also need to be edited so that fields in the header record exactly match the standard Outlook fields.
Open Database Connectivity ODBC drivers are required to import files created with these programs. These drivers are installed by running Setup from the Dataacc.exe file included with the Valupack furnished with Outlook. Users who do not have Office 97 or an Outlook 98 compact disc may download Dataacc.exe from the Outlook Enhancements Web by following these steps:
Generating a Sample of Outlook FieldsBefore editing your data source, it may be helpful to generate a sample of the fields used in Outlook. To generate the sample fields, follow these steps:
Automatic Mapping of FilesIf you use any of the following personal information management (PIM) software products, the Import and Export Wizard includes the ability to automatically assign corresponding field names to closely matching Outlook field names.
For more information on importing and exporting data files, please see the following article(s) in the Microsoft Knowledge Base:
Title : OL98: How to Map Imported Files into Outlook Using Excel
Title : OL98: Importing from Microsoft Excel Requires Named Range
Title : OL98: Data Missing When Importing and Exporting
For more information about adding new components to your Outlook installation, in the Office Assistant, type add components, click Search, and then click to view Setup or remove individual components.
DataViz, Inc., and the distributors of the various products listed above are vendors independent of Microsoft; we make no warranty, implied or otherwise, regarding these product's performance or reliability.
Contact us for more help
Connect with Answer Desk for expert help.