Importing and Exporting Data

From Recital Documentation Wiki
Revision as of 10:34, 14 January 2010 by Yvonnemilne (Talk | contribs)

Jump to: navigation, search

Importing and Exporting Data

The into, save as and to clauses supported by the SQL select statement offer a wide range of export formats for the selected rows.

Import From Text Files

Import from XML

The SQL insert statement allows data to be imported from an XML file:

insert into <table> from [xml] <xml filename>

Example

insert into products;
  from xml prices.xml

Import Live Data using SQL Connectivity Functions

Export to Text Files

select <column-definition> from <table-definition> to file <filename>

Examples

select * from shippers to file shiptxt

Export to XML

select <column-definition> from <table-definition> into xml <xml filename>

or

select <column-definition> from <table-definition> save as xml <xml filename>

Examples

select employeeid, lastname, firstname;
  from employees save as xml emp

Export to HTML

select <column-definition> from <table-definition> into html <html filename>

Export to JSON

select <column-definition> from <table-definition> into json <filename>

Summary