See if the info here helps:
http://support.microsoft.com/kb/196743/en-us
"amy eliza" wrote in message
...
Hi i am unable to transfer my database as it is coming up with an error
that
the excel file has no named ranges. Use microsoft excel to name the range
of
data you want to import.
Could someone please tell me how to do this.