Online Documentation for SQL Manager for SQL server

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 context menu group and proceed to the Import Data... item within this group.

Alternatively, you can open the Data tab of Table Editor / View Editor, right-click the grid there, then select the Data Manipulation context menu group and proceed to the Import Data to <object_name>... item within this group, or use the Import Data item of the Navigation bar.

• Setting source file name and format
• Selecting the source to import data from
• Setting correspondence between the source and target columns
• Adjusting common data formats
• Setting advanced column formats
• Setting import mode and data write type
• Customizing common import options
• Importing data