importing named ranges from excel

A

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?
 
J

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
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Top