Help with ImortXML Method, or point me to good source?

[H3rk]

Ive been trying to set up code to automatically import an XML document but the simple examples just aren't working.

I've used the examples in

http://msdn.microsoft.com/library/default.asp?url=/library/en-us/dnacc2k2/html/odc_accessxml.asp

and

http://www.databasejournal.com/features/msaccess/article.php/1465481

but the format isnt working at all.

I use

Public Sub NutLog()
  Dim sXMLPath As String
  Const cOverWrite As Integer = 1
  sXMLPath = "C:\Documents and Settings\Me\My Documents\ImportFile.xml"
  
    ImportXML sXMLPath, acStructureAndData, cOverWrite

End Sub

and I'm unsure where I would plug in

Application.ImportXML _
    DataSource:="C:\Documents and Settings\Me\My Documents\ImportFile.xml", _
    ImportOptions:=acStructureAndData

I would like to overwrite the previous import each time it executes. I would like it to trigger when the project opens. But I'm not sure how.

 

[H3rk]

I jumped the gun....OfficeSpace has the right answer..

http://www.microsoft.com/technet/scriptcenter/resources/officetips/oct05/tips1020.mspx

Sub ImportNutrition()

Set objAccess = CreateObject("Access.Application")
objAccess.OpenCurrentDatabase "C:\Documents and Settings\Me\My Documents\MyFile.mdb"

objAccess.ImportXML "C:\Documents and Settings\Me\My Documents\MyFile.xml", acAppendData


End Sub

well maybe it will answer some other novices question.