You need a named range. See
http://www.slipstick.com/Tutorials/import/import.htm for the steps.

--
Diane Poremsky [MVP - Outlook]
Need Help with Common Tasks? http://www.outlook-tips.net/beginner/
Outlook 2007: http://www.slipstick.com/outlook/ol2007/

Outlook Tips by email:


EMO - a weekly newsletter about Outlook and Exchange:


Outlook Tips: http://www.outlook-tips.net/
Outlook & Exchange Solutions Center: http://www.slipstick.com

You can access this newsgroup by visiting
http://www.microsoft.com/office/comm...s/default.mspx or point your
newsreader to msnews.microsoft.com.


wrote in message
...
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.