Repost: Method XMLURL of object ISpreadsheet Failed

[rusty cranbrook]

I am trying to load an xml file, created by Access 2002, into an OWC
10 spreadsheet control. The xml file represents a simple table. I can
load the xml file into IE and it's shown as a regular xml file.
However when I use the XMLURL method of the OWC spreadsheet control I
get the following error:

"Method 'XMLURL' of object 'ISpreadsheet' Failed"

I've included the full path to the file. The OWC 10 control is placed
onto an Access 2002 form. According to my understanding, this should
work, but obviously I have something wrong.

 

[Alvin Bruney]

XML needs to be formatted in a very specific way to load into the
spreadsheet. Outside of that, it's often easier to use CSV format as a
source of data transfer. It is just a lot less hassle. If you absolutely
must use XML. Download the office toolpack, crack open the XMLDATA example
and observe the special header and footer tags which must be added to the
xml to allow it to load. Then incorporate it in your application.

 

[rusty cranbrook]

Thanks Alvin. Seems obvious now that you mention it.