Importing Access table into existing XML document

[bigcolin]

Hi,

Does anyone know of a way to import a table of keyed data (Microsoft Access!!, just 2 columns including the primary key) into an existing XML Document which has an empty tag allocated for it? I would like to do all this server side since I am stuck with legacy browser issues where I currently generate XHTML from XML/XSD.

The web server is a windows 2000 server and perhaps there is some utility built into IIs that would do this?

Any help or suggestions would be much appreciated

Colin

 

[palbano]

>> perhaps there is some utility built into IIs that would
>> do this?

No. Even though it is almost 2003, you still have to write code to produce software. Just not as much, most of the time

If you are running on .NET all the classes are there for manupulating XML DOM structures.

If not, you can use the MSXML ActiveX control to load your existing document then use the DOM interface to create and insert the new elements from your SQL data results.

-pete