Exporting

Exporting data from DataVision 2007 is achieved via the Data Grid pop-up menu. The 'Export...' menu opens a 'Save' dialog that allows you to select from many commonly used formats; HTML, XML, CSV, XLS, DOC and more. Each of the formats can be customized to export just what you need.

File Formats

• Advanced Data Tablegram (ADTG).
• Client Dataset (CDS).
• Comma Separated Values (CSV).
• Hypertext Markup Language (Web Page) (HTML).
• Microsoft Excel® Spreadsheet (XLS).
• Microsoft Word® Document (DOC).
• Structured Query Language script (SQL).
• Tab Separated Values (TSV).
• Unformatted Text (TXT).
• eXtensible Markup Language (XML).

Each of the above formats have additional options that allow you to specify exactly how you would like DataVision 2007 to produce the resulting file.

ADTG - Advanced Data Tablegram

Advanced Data Tablegram (ADTG), is a proprietary Microsoft ADO format. This format is typically used for 'Briefcase' style software applications for saving offline data.

CDS - Client Dataset

Client Dataset (CDS), is a proprietary Borland format. This format, like ADTG is typically used for 'Briefcase' style software applications for saving offline data. The format allows saving of all types of data including large binary fields and image data.

CSV - Comma Separated Values

Comma Separated Values (CSV), is a 'flat file' format commonly used for inter-application data transfer. This is a common format used for outputting data that is intended to be read by a spreadsheet application, like Microsoft® Excel.

DOC - Microsoft Word® Document

Microsoft Word® Document (DOC), is a proprietary Microsoft word processor format. DataVision 2007 exports the selected data as a formatted table in the document.

HTML - Hypertext Markup Language (Web Page)

Hypertext Markup Language (HTML), is a tag based text format predominantly used for displaying in web browsers. DataVision 2007 exports the selected data as a formatted table in the document.

SQL - Structured Query Language script

Structured Query Language script (SQL), is a query based language commonly using for information update and retrieval in relational databases.

DataVision 2007 allows the selected data to be output to a 'script' file as a number of INSERT, UPDATE, or DELETE statements. These statements can be fully customized with column mappings and where clauses. User selectable line and batch separators are also provided.

TSV - Tab Separated Values

Tab Separated Values (TSV), is a 'flat file' format commonly used for inter-application data transfer. This is a common format used for outputting data that is intended to be read by a spreadsheet application, like Microsoft® Excel.

TXT - Unformated Text

Unformatted Text (TXT), is a file format without any column or line separators. This format is generally used when exporting data in the form of text that the database has returned as multiple rows. An example of this would be XML returned by Microsoft SQL Server.

XLS - Microsoft Excel® Spreadsheet

Microsoft Excel® Spreadsheet (XLS), is a proprietary Microsoft spreadsheet format. DataVision 2007 exports the selected data as a formatted sheet in the workbook.

XML - eXtensible Markup Language

eXtensible Markup Language (XML), is a standardized tag based text format. DataVision 2007 supports several different formats for exporting data as XML.

• Client Dataset compatible XML. An XML format that includes metadata information that can be read by Borland's Client Dataset.
• ADO Compatible XML. An XML format that can be read by ADO recordsets.
• Plain XML. Produces XML in the standard international format. Field data can be specified to be outputted as Attributes or as Elements. Metadata can also be optionally selected.