Select the product you need help with
- Internet Explorer
- Windows Phone
- More products
OL98: Importing from Microsoft Excel Requires Named Range
Article ID: 180315 - View products that this article applies to.
This article was previously published under Q180315
In Microsoft Outlook 98, when you try to import Calendar, Contact, or Task information from Microsoft Excel, you may receive one of the following messages:
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 named range in the Microsoft Excel file. Or the range name used is the same as one of the column header names in the range.
To successfully import information using a Microsoft Excel file, define a named range in your Microsoft Excel worksheet. The name assigned to the range should not be the same as one of the column header names.
To Define a Named RangeTo define a named range in Microsoft Excel, follow these steps:
Outlook uses the Open Database Connectivity (ODBC) method when importing information. When you import a file from Microsoft Excel, ODBC requires that the information be contained within a named range in the Microsoft Excel file. Using the range naming procedure above, the range name may default to a field name in the selected range. This name should be changed 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: January 4, 2000 - Revision: 1.0