Access 07 XML file import automation

I require the ability to import an XML file provided by a supplier into an Access Database. The database should load a form with a textbox asking for the location of the XML file, a submit button that once clicked imports the file (based upon the XML location entered in the textbox). I will supply the access database and sample XML files. The database contains the form which has the textbox and submit button. You will be required to build the tables, XSD file and code the VBA to automate the import to update the tables. The XML files can not be modified. I will take the code/XSD file you've created and modify another database so you must not encrypt/hide the code and will be required to comment it to ensure we can understand the process.