Is there anyone know how to export data to a XML file or
import data from a XML file directly?
Any help is appreciated.
>exporting is easy, checkout BOL on "FOR XML"
>*** Sent via Developersdex http://www.developersdex.com
>Don't just participate in USENET...get rewarded for it!
I need to import an XML file(s) into SQL Server, and
subsequently export data in an xml format from SQL
Server. I tried using the DTS import/export text file
facility, but was very surprised that there weren't any
options for an xml formatted text file. Am I missing
something? I find it nearly impossible to believe that
SQL Server 2000 doesn't have a native means of importing
and exporting from/to an xml formatted file. Can anyone
suggest a means of accomplishing my objective?
I'm running SQL Server 2000 on Windows XP.