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 | 
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 | Import Data to <object_name>... context menu item.
- Setting source file name and format
- Selecting the source to import data from
- Setting correspondence between the source and target fields
- Adjusting common data formats
- Setting advanced field formats
- Setting import mode and data write type
- Customizing common import options
- Importing data
|
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. |
|
