Copy Excel Data To MSSQL DB Table

1. This utility helps to save Excel data in MSSQL Table 2. If table name mentioned in the Parameters is available, it will insert the data in the existing table. Or else it will create the table. 3. Excel Headers are considered as table Headers if it the bot creates Table

1. Data of a column should be in single format except column header if exist 2. Though special charaters will be considered as columns avoiding the same is one of the best practices 3. If ODBC Connection String is given Database/User/Host/Password are not required to be passed. And viceversa is also applicable. 4. Even though Database information is passed, it will not be considered if ODBC Connectioin string is available. 5. All columns will be in nvarchar(MAX) datatype if new table is created through bot. 6. Excel columns should be in same order as same as SQL Table column order.