Online Documentation for SQL Manager for DB2

Import Data Wizard


Import Data Wizard allows you to import data to a table / view from any of supported formats (MS Excel, MS Access, DBF, XML, TXT, CSV, HTML, MS Excel 2007, MS Word 2007, ODF). You can save your settings as a template any time for future use.

 

To start the wizard, right-click the table/view in DB Explorer, select the Data Manipulation | iconTools_ImportData Import Data... context menu item.

Alternatively, you can open the Data tab of Table Editor / View Editor, right-click the grid there, then select the Data Manipulation | iconTools_ImportData Import Data to <object_name>... context menu item.

 

menuImportData

 

 

 

 

Availability:

Full version (for Windows)

Yes

Lite version (for Windows)

No

Note: To compare all features of the Full and the Lite versions of SQL Manager, refer to the Feature Matrix page.