Need to import and XML document from the web to an Access database

[Gumster]

Hello!

I have a http:// link to an .asp page which outputs xml data that I need to import into an access database.
Not very good at vba so any help is welcome. Need to open a connection to the web page, import the data in the document to the correct tables.
I've tried downloading the xml file and import it via access import wizard but I only get one table with null values.

 

[Gumster]

Need to loop through the values and put them in an access DB. Any ideas on how to proceed? XLS stylesheet or XMLDom?

The xml structure looks like this:



- <curve id="22186" title="Avg TT All ECM12 D1 FW" type="forecast">
- <entry date="2005-01-01 00:00:00">
<point date="2005-01-01 00:00:00" value="6.555117152" />
<point date="2005-01-02 00:00:00" value="6.462998603" />
<point date="2005-01-03 00:00:00" value="4.725106396" />
<point date="2005-01-04 00:00:00" value="6.437339408" />
<point date="2005-01-05 00:00:00" value="6.349340822" />
<point date="2005-01-06 00:00:00" value="7.874444944" />
<point date="2005-01-07 00:00:00" value="8.887169017" />
<point date="2005-01-08 00:00:00" value="7.333827835" />
<point date="2005-01-09 00:00:00" value="7.608938237" />
<point date="2005-01-10 00:00:00" value="10.24687719" />
</entry>
- <entry date="2005-01-02 00:00:00">
<point date="2005-01-02 00:00:00" value="6.289055597" />
<point date="2005-01-03 00:00:00" value="4.774978078" />
<point date="2005-01-04 00:00:00" value="6.429045012" />
<point date="2005-01-05 00:00:00" value="6.448217534" />
<point date="2005-01-06 00:00:00" value="7.958552781" />
<point date="2005-01-07 00:00:00" value="8.906700241" />
<point date="2005-01-08 00:00:00" value="9.692632851" />
<point date="2005-01-09 00:00:00" value="6.342090249" />
<point date="2005-01-10 00:00:00" value="4.271948205" />
<point date="2005-01-11 00:00:00" value="2.97476944" />
</entry>