You are currently offline, waiting for your internet to reconnect

OL98: Importing from Microsoft Excel Requires Named Range

This article was previously published under Q180315
Retired KB Content Disclaimer
This article was written about products for which Microsoft no longer offers support. Therefore, this article is offered "as is" and will no longer be updated.
In Microsoft Outlook 98, when you try to import Calendar, Contact, or Taskinformation from Microsoft Excel, you may receive one of the followingmessages:
An error has occurred in the Microsoft Excel translator while getting the contents of a file system.

The Microsoft Excel file '<Drive\Directory\Filename>' has no named ranges. Use Microsoft Excel to name the range of data you want to import.
An ODBC error has occurred in Microsoft Excel translator while opening a file to build a field map. Microsoft ODBC Excel driver: too many fields defined.
The information you are trying to import is not contained within a namedrange in the Microsoft Excel file. Or the range name used is the same asone of the column header names in the range.
To successfully import information using a Microsoft Excel file, define anamed range in your Microsoft Excel worksheet. The name assigned to therange should not be the same as one of the column header names.

To Define a Named Range

To define a named range in Microsoft Excel, follow these steps:
  1. In your Microsoft Excel worksheet, select the rows and columns that contain the information that you want to import.
  2. On the Insert menu, point to Name, and then click Define.
  3. In the Names In Workbook box, type a name (the name may not contain spaces nor should it be the same as one of the column header names) for the range that you specified, and then click Add.
  4. Click OK, and on the File menu, click Save.
  5. Save and quit the workbook.
Outlook uses the Open Database Connectivity (ODBC) method when importinginformation. When you import a file from Microsoft Excel, ODBC requiresthat the information be contained within a named range in the MicrosoftExcel file. Using the range naming procedure above, the range name maydefault to a field name in the selected range. This name should bechanged to a non-column header name.

An alternative method is to save the information from Excel using the comma separated value (CSV) format and then import the CSV file into Outlook. This method does not require using name ranges in Excel.

Article ID: 180315 - Last Review: 01/04/2000 12:20:00 - Revision: 1.0

  • Microsoft Outlook 98 Standard Edition
  • kbprb KB180315