OL2000: When You Try to Import Contacts into Outlook by Using a Comma-Separated Values File, the Operation Is Unsuccessful (329922)

WORKAROUND

To work around this issue, create a .csv file that uses the format expected by Outlook.

To do this, first export your Outlook contacts into a .csv file that will be used as a template. Then, copy the data out of the .csv file created by your e-mail program and paste it into the template file. This template file can then be used to successfully import your data into Outlook.

To do this, follow these steps:

1. Start Outlook.
   
   To create the template file, follow these steps:
   1. On the File menu, click Import and Export.
   2. In the Import and Export Wizard, click Export to a file, and then click Next.
   3. Click Comma Separated Values (Windows), and then click Next.
   4. In the Select folder to export from pane, click Contacts, and then click Next.
   5. In the Save exported file as box, type c:\contacts.csv, and then click Next.
   6. Click Finish.
   7. When the export is complete, open the .csv file in Microsoft Excel.
2. Open the .csv file created by your original e-mail program in Excel, and then arrange the Excel windows so that both files are visible. Position the file created by the original e-mail program on the left side of your screen, and then position the file created by Outlook on the right side.
   
   NOTE: The types of data in both files will be very similar. However, if you examine the column headings in row 1, you will notice that the headings have different names and appear in a different order.
   
   
3. Determine which column in the file on the right contains similar data to the first column in the file on the left. Select all the data in the first column in the left file (but not the column heading), and then paste it into the corresponding column in the right file.
   
   NOTE: Do not to paste over the column headings in row 1.
   
   
4. Repeat step 3 for each column of data contained in the left file.
5. Save and close the right file.
6. Start Outlook.
7. On the File menu, click Import and Export.
8. In the Import and Export Wizard, click Import from another program or file, and then click Next.
9. Click Comma Separated Values (Windows), and then click Next.
10. In the File to import box, type c:\contacts.csv, and then click Next.
11. In the Select destination folder pane, click Contacts, and then click Next.
12. Click Finish.