IMPORT XML Data To Access 2003
Posted on 2006-03-20
I want to "append the XML data to an existing table" and it is easy to do it "manually" through
File > Get External Data > Import > *.XML (chosen) > (Import Options) "Append Data to Existing table(s)"
but... I want my Access 2003 database, based on the server, to run this routine from an XML data presented also in the server... automatically, from 2 to 2 hours, from (say) 11: am till 4:00 pm (USA time) , from Monday till Friday.
I know I have to use VBA or some Access macro but... I am a newbie in those tools (although I can "read and make small code adjustments" with ease). Could someone help me with this coding?