Online Documentation for Data Import for DB2

Supported file formats


RadioButton MS Excel 97-2003

The most popular e-table format used by Microsoft® Excel (*.xls). The result files are fully compatible with Microsoft® Excel versions 97-2000, 2003 and XP.

 

RadioButton MS Access

File of Microsoft® Access format (*.mdb, *.accdb) with an ADO connection used.

 

RadioButton HTML

Hyper Text Markup Language file format (*.html, *.htm), complete compatibility with HTML 4.0 specification.

 

RadioButton Text file

Plain text file format (*.txt).

 

RadioButton CSV file

Comma-Separated Value file format (*.csv).

 

Note: all the text formats including Text file, CSV are usually used as working or interchange formats.

 

RadioButton XML

A markup language for documents containing structured information (*.xml).

 

RadioButton DBF

Database file format (*.dbf)used by dBASE and a number of xBASE applications.

 

RadioButton MS Excel

The contemporary e-table format used by Microsoft® Excel (*.xlsx). The result files are fully compatible with Microsoft® Excel 2007.

 

RadioButton MS Word

The contemporary text processing format used by Microsoft® Word (*.docx). The result files are fully compatible with Microsoft® Word 2007.

 

RadioButton ODF Spreadsheets

OASIS Open Document Format for Office Applications - open document file format for spreadsheets (*.ods) used by a number of applications including OpenOffice.org and KOffice.

 

RadioButton ODF Text

OASIS Open Document Format for Office Applications - open document file format for word processing (*.odt) documents used by a number of applications including OpenOffice.org and KOffice.