Online Documentation for Advanced Data Import for RAD Studio VCL

Advanced Data Import Component


EMS Advanced Data Import for RAD Studio VCL represents a set of tools for importing data to any TDataset component from files in different formats, such as Microsoft Excel, Microsoft Access, DBF, XML, CSV, TXT, HTML, DOCX, ODT, ODS, XLSX, and XML Document.

 

From a programmer's point of view the component represents a homomorphic hierarchy of classes with the common ancestor TQImport3. Beside the basic properties, methods and events, some specific characteristics are included in descendant classes.

 

The TQImport3Wizard component allows you to define all the import settings and import your data to the dataset from Excel, DBF, XML, CSV and TXT files within a dialog window. Using TQImport3Wizard you can add all the functionality of Advanced Data Import for RAD Studio VCL to your application within a single line of code!

 

Advanced Data Import for RAD Studio VCL provides a collection of the following components:

 

Component

Brief description

TQImport3

Common data import component

TADO_QImport3Access

Provides data import from MS Access databases

TQImport3ASCII

Provides data import from CSV and TXT files

TQImport3DataSet

Provides data import from a TDataSet component.

TQImport3DBF

Provides data import from DBF files

TQImport3Docx

Provides data import from MS Word tables

TQImport3HTML

Intended for importing tables from HTML pages

TQImport3ODS

Provides data import from OpenDocument Spreadsheet files (Open Document format)

TQImport3ODT

Provides data import from the tables of OpenDocument Text files (Open Document format)

TQImport3Wizard

Provides a dialog window to define all the import settings

TADO_QImport3Wizard

Provides the same functionality as TQImport3Wizard component, including import from Access

TQImport3XLS

Provides data import from XLS files

TQImport3XLSx

Intended for importing the MS Excel sheets

TQImport3XML

Provides data import from XML files

TQImport3XMLDoc

Provides data import from generic XML files using XPath and DataLocation (tlAttributes, tlSubNodes)