Online Documentation for Data Import for DB2
Supported file formats
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.
MS Access
File of Microsoft® Access format (*.mdb, *.accdb) with an ADO connection used.
HTML
Hyper Text Markup Language file format (*.html, *.htm), complete compatibility with HTML 4.0 specification.
Text file
Plain text file format (*.txt).
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.
XML
A markup language for documents containing structured information (*.xml).
DBF
Database file format (*.dbf)used by dBASE and a number of xBASE applications.
MS Excel
The contemporary e-table format used by Microsoft® Excel (*.xlsx). The result files are fully compatible with Microsoft® Excel 2007.
MS Word
The contemporary text processing format used by Microsoft® Word (*.docx). The result files are fully compatible with Microsoft® Word 2007.
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.
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.