Import/Export XML Data

[flash99]

Import/Export XML Data

Basically, I want to do the following:

Import XML data from Microsoft SQL Server 2000 in order to use it with Microsoft Access XP
Export XML data from Microsoft Access XP in order to use it with Microsoft SQL Server 2000

I am aware how to create the XML data, but I still don't understand how would I be able to format the XML so that it will work for Microsoft SQL Server and Access.

I guess what I am thinking of is some sort of engine between Microsoft SQL Server 2000 and the application so that the XML data can be formatted.

I have also been looking at the FOR XML EXPLICIT, that is away in which it is possible to specify the format of the XML data. The only problem with this method is that you have to know how the database or the table structure is first in order to proceed with the mapping, and this will only work on one specific database.

If you have a look at Microsoft Access and try importing a table in XML format you will notice that the application will create two files which contains the data and the schema. And this is similar to what I want to do, to be able to import and export and be able to specify the format of the resultant data.

So if anyone has any idea or might be able to assist me I would really appreciate it!

Best regards!