Connecting to MSSQL

1. Click the Import from button in step 2 of the Import Wizard.

   

2. Under Provider tab in the Data Link Properties, select Microsoft OLE DB Provider for SQL Server.
   Under Connection tab, choose the data source and database from the Select or enter a server name and Select the database on the server drop-down list respectively.
   
   
   



3. All available tables will be included in the list if connection success. Just simply choose the tables you wish to import or specify a query using Add Query button.