Q:

Importing xml file and referencing an xsd file

I am trying to find a way to import an xml file, with an xsd that is a seperate file (not embedded in the xml).
 Application.ImportXML DataSource:=varResult, ImportOptions:=acAppendData

is the basic way I know how to import an xml file (where varResult is a variable being passed form a FilePicker routine). As far as I know there are three basic arguments you can use, and this has nothing to do with what I am trying to get at. If I was to import the xml file I have it would not create multiple records for one of the tables; rather those values would just overwrite the previous record.
I know how to just go through the nodes, with nodelist, grab the values manually, loop through that, build temp tables, and migrate the data from the temps to the proTables, but that is alot of coding, just to make up for the fact that I just don't know how to programmatically reference an xsd file, in order to use the generic import command.

A:

AFAIK there is no ImportXML option to reference a separate xsd file.  But since you know the names and locations of your xml and xsd files, perhaps you could merge them and feed to merged file to ImportXML.
I haven't tried this myself, but suspect you could do the merge in 2 ways:

add the xsd tag lines to the xml file's root
change the xml dataroot to include xsi:noNamespaceSchemaLocation="YourXsdFile.xsd"

Both of those approaches seem kind of kludgey.  The question is ... can you do it with significantly less code than it takes to open the xml doc and then parse and store the values?  

