Connect Window helps you to setup your connection to database. There are two methods to connect: with predefined data source or using direct connection to server or database file. In the first case you need to setup connections properties with Windows ODBC Administrator outside the Import Table from Excel for SQL Server tool.

Most important connection settings are:

• Database Server or Data File name
• User name or Login
• Password

Also, you may specify additional properties of the connection:

• Database name (not for all types of DBMS)
• Owner or Schema name
• Transaction size (how many rows will be processed per transaction)