The error message tells you exactly what is wrong - you have no named ranges.

--�
Milly Staples [MVP - Outlook]

Post all replies to the group to keep the discussion intact.
How to ask a question:
http://support.microsoft.com/KB/555375


After furious head scratching, asked:

| I have been trying to import data saved to an excel workbook but when
| I go through the normal import process this is what I get as an error
| message. Does anyone have the answer as to how to name the data range
| in excel??
|
|
| An error has occurred in the Microsoft excel 97-2003 translator while
| getting the contents of a file system.
| The microsoft Excel 97-2003 file C:\User\Terry Daw|documents
| \Morelsoftware\Sales Force\contact.xls
| Has no maned ranges. Use Microsoft 97-2003 to name the range of data
| you want to import.