Import from External Source

You use the Import from External Source dialog box to specify the database object (or SQL statement) you want to select from the relational database for conversion to XML. This dialog box appears after you specify the OLE DB provider and server connection settings in the ADO to XML document wizard.


Database Object

The type of database object you want to convert to XML (table or view, for example).

Object Name

The name of the database object you want to convert to XML.

SQL Statement

Instead of specifying a database object explicitly, you can choose to enter an SQL statement to query a database. In this case, the query result is returned as an XML document when you run the document wizard.

For More Information

Creating XML from ADO

Using Document Wizards to Create XML

Chapter 12Accessing Relational Data as XML

Free Stylus Studio XML Training:
W3C Member