importxml produces runtime error

Thread view:

Enable EMail Alerts

Start New Thread

Thread rating:

_prefix - 15 Dec 2005 10:10 GMT

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")

Reply to this Message

Alex Dybenko - 16 Dec 2005 05:53 GMT

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

at me this works fine (access 2003 sp2)

Signature

Alex Dybenko (MVP)
http://alexdyb.blogspot.com
http://www.PointLtd.com

> is anyone finding a problem with importxml?
>
[quoted text clipped - 13 lines]
> keyword and perform customary case translation (i.e.,
> "imPoRtOptions"->"ImportOptions")

Reply to this Message

_prefix - 16 Dec 2005 16:20 GMT

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

> Hi,
> try to specify exact path:
[quoted text clipped - 19 lines]
> > keyword and perform customary case translation (i.e.,
> > "imPoRtOptions"->"ImportOptions")

Reply to this Message

Alex Dybenko - 17 Dec 2005 15:06 GMT

Hi,
without full path I got weird automation error

Signature

Alex Dybenko (MVP)
http://alexdyb.blogspot.com
http://www.PointLtd.com

> 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
[quoted text clipped - 27 lines]
>> > keyword and perform customary case translation (i.e.,
>> > "imPoRtOptions"->"ImportOptions")

Reply to this Message