Please start any new threads on our new
site at https://forums.sqlteam.com. We've got lots of great SQL Server
experts to answer whatever question you can come up with.
| Author |
Topic |
|
flash99
Starting Member
3 Posts |
 Posted - 2003-04-11 : 05:45:19
|
| Import/Export XML DataBasically, I want to do the following:Import XML data from Microsoft SQL Server 2000 in order to use it with Microsoft Access XPExport XML data from Microsoft Access XP in order to use it with Microsoft SQL Server 2000I 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! |
|
|
robvolk
Most Valuable Yak
15732 Posts |
Posted - 2003-04-11 : 07:10:39
|
| http://www.sqlteam.com/forums/topic.asp?TOPIC_ID=25126Um, you STILL don't need XML for Access and SQL Server to communicate with each other. Your external application might need XML, but that's simply a matter of exporting the data from wherever it resides and formatting it as XML. XML is not going to help you move data between Access and SQL Server, it will only hinder you. |
 |
|
|
|
|
|
Import/Export XML Data