Importing xml to .mdb - Help!

[ForcedToUseIt]

Hi, I want to automatically import an .xml file into a table that i have in my .mdb. Is this possible and if so, how do I do it?
If you could point me in the right direction that would also be great.

Thanx in advance...

 

[ecniv]

A person in another forum is doing something like this. He was using Ado and opening a source in that to the xml file and using then sort of like nodes and sub levels properties. Not sure myself.

The alternative is to create a text parser that reads through the file and deciphers it as applicable. You'd still need the doc source though to know what type of data to expect...

 

[ForcedToUseIt]

I want to import the document from code only so the user will not have to be involved in the process. Other than just pressing a button to import the data.

I will post the solution when i'm done. But I'm swamped at the moment so it will take some time.