A
Arvi Laanemets
Hi
During last days I encoutered a problem. When trying to create an ODBC query
from Excel tables, ODBC don't see any named ranges in source workbook, when
the source workbook is closed. When I open the source workbook, named ranges
in source workbook are visible and I can create the query. But when I close
after that the source workbook, and try to refresh the query, the error
message is displayed:
[Microsoft][ODBC Excel Driver] The Microsoft Jet database engine could not
find the object "MyNamedRange". Make sure the object exists and that you
spell its name and the path correctly."
All queries created earlier are working normally. The source workbook I was
working with, is situated on shared network resource which is mapped to my
computer, but the ODBC behaviour remained same, when I copied it to my
computer and tried to access it there - so this is not signifant.
From MS KB I didn't fint anything applicable.
Hope for some advice here. Thanks in advance!
During last days I encoutered a problem. When trying to create an ODBC query
from Excel tables, ODBC don't see any named ranges in source workbook, when
the source workbook is closed. When I open the source workbook, named ranges
in source workbook are visible and I can create the query. But when I close
after that the source workbook, and try to refresh the query, the error
message is displayed:
[Microsoft][ODBC Excel Driver] The Microsoft Jet database engine could not
find the object "MyNamedRange". Make sure the object exists and that you
spell its name and the path correctly."
All queries created earlier are working normally. The source workbook I was
working with, is situated on shared network resource which is mapped to my
computer, but the ODBC behaviour remained same, when I copied it to my
computer and tried to access it there - so this is not signifant.
From MS KB I didn't fint anything applicable.
Hope for some advice here. Thanks in advance!