Importing and Exporting Data To and From the Database

Importing a Text File

For files less than 30KB, you can copy and paste tab-delimited data directly into the Import Text Wizard. For files larger than 30KB, you must upload a separate file.

To import a text file:

1. Navigate to the Data Import/Export page:

   1. Click the SQL Workshop icon on the Workspace home page.

   2. Click Utilities.

   3. Click Data Import/Export.

2. Click Import.

3. Click Import Text Data.

   The Import Text or Spreadsheet Data Wizard appears.

4. Under Import To, select either Existing table or New table.

5. Under Import from, select either Upload file or Copy and paste.

6. Follow the on-screen instructions.

Importing an XML Document

Data Workshop supports the import of XML documents adhering to the Canonical XML specification.

To import an XML document:

1. Navigate to the Data Import/Export page:

   1. Click the SQL Workshop icon on the Workspace home page.

   2. Click Utilities.

   3. Click Data Import/Export.

2. Click Import.

3. Click Import XML Data.

   The Import XML Wizard appears.

4. Follow the on-screen instructions.

Importing Spreadsheet Data

You can load spreadsheet data by either copying and pasting text, or by importing a file. To copy and paste text, the spreadsheet file must be less than 30KB. For files larger than 30KB, you can import the file in a delimited format (such as comma-delimited (.csv) or tab-delimited), upload the file, and then load the data into a new or existing table.

To import spreadsheet data:

1. Navigate to the Data Import/Export page:

   1. Click the SQL Workshop icon on the Workspace home page.

   2. Click Utilities.

   3. Click Data Import/Export.

2. Click Import.

3. Click Import Spreadsheet Data.

   The Import Spreadsheet Data Wizard appears.

4. Under Import to, select either Existing table or New table.

5. Under Import from, select either Upload file or Copy and paste.

6. Follow the on-screen instructions.

Viewing the Import Data Repository

You can view imported information in the Text Data Import Repository.

To view imported data:

1. Navigate to the Data Import/Export page:

   1. Click the SQL Workshop icon on the Workspace home page.

   2. Click Utilities.

   3. Click Data Import/Export.

2. Click Import Repository.

3. To filter the view, make a selection from the Show list and click Go.

4. To view details about the imported file, click the Details icon.

5. To download a file, click the file name.

6. To delete a file, select the check box adjacent to the file name and click Delete Checked.

Exporting to a Text File

Use the Export Text Data Wizard to export the contents of a table to a text file. For example, you could export an entire table to a comma-delimited file (.csv).

To export a table to a text file:

1. Navigate to the Data Import/Export page:

   1. Click the SQL Workshop icon on the Workspace home page.

   2. Click Utilities.

   3. Click Data Import/Export.

2. Click Export.

3. Click Export To Text.

   The Export to Text Wizard appears.

4. Follow the on-screen instructions.

You select the schema and choose the table and columns to be exported. You can also specify the type of separator to be used to separate column values as well as whether column text strings are identified using single or double quotation marks.

Exporting to an XML Document

Use the Export XML Wizard to export the contents of a table to an XML document adhering to the Canonical XML specification.

To export a table to an XML document:

1. Navigate to the Data Import/Export page:

   1. Click the SQL Workshop icon on the Workspace home page.

   2. Click Utilities.

   3. Click Data Import/Export.

2. Click Export.

3. Click Export to XML.

   The Export to XML Wizard appears.

4. Follow the on-screen instructions.

You select the schema and choose the table and columns to be exported.