VB6 and XML import

[abaldwin]

Have a vb6 application with an Access backend db (used only for storage).

Would like to do the following:
1. Export certain records from 12 tables into XML (have done this fine with ado.save <filename> adpersistxml).

These files would then be sent via email to some remote users who would need to then...

2. Using the application - Import the data from the 12 files into their local copy of the database.

Number 2 is where I would like some help and possibly some examples.

The databases on both ends are identical would just like the simplest way to write the VB6 code to do the import.

Thanks


Andy Baldwin

 

[SgtPeppa]

I know I am not being very helpful here but you might want to post this in the 'VisualBasic (Microsoft): Version 5 & 6' Forum to get the best response! This is not really an Xml Problem.

 

[taupirho]

Haven't done it for Access but have for Oracle. Follow the link below to see how. Won't be exactly the same but should give you 90% of the code you need.

http://the-big-o.port5.com/article65.shtml