importing named ranges from excel

[amk]

Hi - I am having trouble importing named ranges from excel 2003 into access
2000 . Even though they exist in the excel workbook, when I go through the
"get external data" process and select "named ranges" they do not appear in
the access dialogue box. Any suggestions?

 

[Jeanette Cunningham]

amk,
here is a test to help find out where the problem is.
Create a new worksheet with some dummy data.
Define at least 2 ranges.
See if you can import the named ranges.
If all goes well, you know there is a problem with the particular worksheet
where the named ranges won't appear.


Jeanette Cunningham -- Melbourne Victoria Australia