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 iconTools_ImportData 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 iconTools_ImportData Import Data to <object_name>... item within this group, or use the iconTools_ImportData Import Data item of the Navigation bar.

 

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.