OL2000: Error Converting Outlook Contacts to Schedule+ (206746)


The information in this article applies to:

  • Microsoft Outlook 2000
This article was previously published under Q206746

SYMPTOMS

When importing Outlook contacts into Microsoft Schedule+ 7.0, you may get one of the following error messages:
The import file has too many fields. Make sure the character you selected to separate the fields matches the separator in the import file and that you select the correct character to surround strings.

-or-

There was a problem importing the file. The problem occurred near line x.
Where x is a line number reference in the converter library.

CAUSE

Outlook stores much more information about contacts than Schedule+. If you export the entire Outlook data set, this generates more fields than the Schedule+ importer can handle. Also, if a date field is empty, it is exported as 0/0/00, which is not acceptable to Schedule+.

RESOLUTION

To correct this problem, import the file into Microsoft Excel for an interim cleanup step. In Excel, remove any empty date fields and any completely unused columns.

MORE INFORMATION

To Export Contacts From Outlook

  1. On the File menu, click Import And Export.
  2. Click Export to a File and click Next.
  3. Click Comma Separated Values (Windows) and click Next.
  4. Click the Contact folder you wish to export and click Next.
  5. Type a path and file name for the file to be exported and click Next.
  6. Click OK and Finish.

To Import and Manipulate Contacts in Excel

  1. On the File menu, click Open.
  2. Navigate to the file exported above and click Open.
  3. On the Edit menu, click Replace.
  4. Type 0/0/00 in Find What.
  5. Leave Replace With blank.
  6. Click Replace All.
  7. Click to select any completely unused columns and on the Edit menu, click Delete.
  8. On the File menu, click Close, click Yes, and then click Save to replace the existing file.

To Import Contacts into Schedule+

  1. On the File menu, point to Import and click Text.
  2. Type or browse to the file name to be imported, and click Next.
  3. Click Yes and then click Next.
  4. Click Comma, click to select the quotation mark (") as character used to surround text fields, and click Next.
  5. Click Contact List and click Next.
  6. Select types for each field in the incoming file.
  7. Click Finish.
NOTE: Once set, Schedule+ retains these settings.

REFERENCES

For information on exporting Outlook appointments to Schedule+, please see the following article in the Microsoft Knowledge Base:

198285 OL2000: How to Convert Outlook Appointments to Schedule+ 95

Modification Type:MajorLast Reviewed:9/29/2003
Keywords:kberrmsg kbinterop kbprb KB206746
©2003 Microsoft Corporation. All rights reserved.