OL98: How to Map Imported Files into Outlook Using Excel
ID: Q189181
|
The information in this article applies to:
SUMMARY
Microsoft Outlook 98 does not have the Field Mapping feature found in
Microsoft Outlook 97. This article describes how to use Microsoft Excel as
an interim step to conveniently map fields from another database into
Outlook 98.
This import process takes six separate but simple steps:
NOTE: To use this procedure, the database program must have the ability to
export data in CSV format.
- From Outlook, export a "pattern" file in comma-separated values
(CSV) format.
- From the database program, export the data you want to import into
Outlook, in CSV format.
- Import both of these CSV files into Microsoft Excel and display
them in tiled windows.
- In Microsoft Excel, manually map the field names from the Outlook
file to the database file.
- In Microsoft Excel, save the database file you want to import
into Outlook, in CSV format.
- In Outlook, import the new database CSV file.
MORE INFORMATIONTo Export a Pattern file from Outlook
- If present, remove the current binary mapping file named,
"Comma Separated Values (Windows).ADR" located in the Windows
folder. This procedure will rebuild this file.
- On the File menu, click Import and Export.
- Click to select Export To A File and click Next.
- Click to select "Comma Separated Values (Windows)" and click Next.
- Click to select the folder into which you plan to import the database
records and click Next.
- Type a name, such as Pattern.csv for the CSV pattern file and click
Next.
- Click Finish.
To Export the Data from the Database Program
Export the data file in CSV format. Refer to the program's online Help or
printed documentation to determine how accomplish this.
To Import and Display the CSV Files in Microsoft Excel
- On the File menu, click Open.
- Click to select "All Files (*.*)" from the Files Of Type list.
- Click to select the database CSV file, and click Open.
- Repeat steps 1 through 3, selecting the Outlook CSV file.
- On the Window menu, click Arrange.
- Click to select Horizontal and click OK.
Microsoft Excel will display the two files with the Outlook file
above the database file.
To Manually Map the Field Names in Microsoft Excel
- Visually compare the field names (column headers) of like data.
- For corresponding fields with different names, right-click the Outlook
field name and click Copy on the shortcut menu.
- Right-click the corresponding field name on the database file and click
Paste on the shortcut menu.
- Repeat steps 1 through 3 for each field where the data corresponds but
the field names differ.
- Click in the Outlook window to activate it, and on the File menu,
click Close.
To Save the Database File in Microsoft Excel
- Remove any unused or unwanted columns from the database file by clicking
to select the column and then on the Edit menu, click Delete.
- On the File menu, click Close.
- Save the file in CSV format by clicking Yes and then Save.
- Quit Microsoft Excel.
To Import the New Database File Into Outlook
- On File menu, click Import And Export.
- Click to select "Import from another program of file", and click Next.
- Click to select "Comma Separated Values (Windows)" and click Next.
- Type or browse to the name of the new database CSV file created above.
- Click to select the desired option for handling duplicate records and
click Next.
- Click to select the folder into which you wish to import the database
records, click Next and then click finish.
REFERENCES
For related information, please see the following articles in the Microsoft
Knowledge Base: Q182728
OL98: Field Mapping for Importing Not Available
Q179556
OL98: How to Import and Export Text Data with Outlook
Additional query words:
98
Keywords : kb3rdparty kbinterop IntpOff IntpImEx
Version : WINDOWS:
Platform : WINDOWS
Issue type : kbhowto
|