Prerequisites
-
If you need to connect to a domain residing in another SQL Server database, make sure you created an ODBC profile for connection to the source database. You cannot use existing profiles that are available for selection in the Import Utility. When creating a new ODBC profile for SQL Server, make sure the new profile name is unique in the Windows registry of the computer where you run the Import Utility.
-
In order to use Excel for the source of the data input or when having issues with the Save as Excel driver, you need to download and install from the Microsoft Downloads Center the Microsoft Access Database Engine 2010. Then add data source to ODBC Data Sources (32- bit) (in System DSN tab) for the driver, and select the Microsoft Excel Driver (*.xls *.xlsx *.xlsm *.xlsb).
Smart Instrumentation supports Microsoft dBase Driver for .dbf files, and Microsoft Text Driver for .txt and .csv files. You can select the driver you require using the ODBC Data Source Administrator in your Windows Administrative Tools.
-
Select Actions > New Group .
-
Select Actions > New Link .
-
On the Link Definitions dialog, under Import method, select Single table or Module (multiple tables) and select the appropriate target table or module from the list.
You can import data only into a target table that has a table definition (for example, a table that has a correct definition of a primary key, foreign keys, and reference tables). If you import data into a target module, all the tables in the target module must have a table definition.
-
Under Source, from the Database type list, select ODBC as the source database platform.
-
From the ODBC profile list, select the required database profile or a file that contains source table definitions.
Your selection affects the way you connect to the SQL data source and the dialog options change accordingly.
-
If you selected a database profile, specify the user name and password for connecting to the source database and select Connect; then, from the Table list, select a table from which you want to import data.
OR
If you selected a data source file, beside File name and path, select Browse and specify the data source file.
If you are creating a new link based on an existing link, select Save as new link.
-
Select Apply and then Close.
-
Select to display the link you defined in the Link Explorer.