importxml produces runtime error

[_prefix]

is anyone finding a problem with importxml?

I wrote this code:
function f1()
Application.ExportXML acExportTable, "sites", , "schema-sites.xml"
end function

function f2()
Application.ImportXML DataSource:="schema-sites.xml",
ImportOptions:=acStructureOnly
end function

when I run these functions in order, a runtime error message is returned.
even if I rename the 'sites' table before importing.
I also noticed the compiler doesn't seem to recognize the importoptions
keyword and perform customary case translation (i.e.,
"imPoRtOptions"->"ImportOptions")

 

[Alex Dybenko]

Hi,
try to specify exact path:
Application.ImportXML "C:\schema-sites.xml", acStructureOnly

at me this works fine (access 2003 sp2)

 

[_prefix]

Alex, as you suggested, full path worked. I am just puzzled as to why it
would matter. Did you test without full path to see if that worked as well?
Thank you for testing it.

my environment: xp home,sp2, access 2003

 

[Alex Dybenko]

Hi,
without full path I got weird automation error