Install
Download the Bot and follow the instructions to install it in your AAE Control Room.
Copy Excel Data To MSSQL DB Table
This bot is used to Save Excel data to MSSQL Table. This bot is provided by ThirdWare.
Top Benefits
- Achieving Best Performance of transferring data to Database
- Avoiding huge commands/codes for Excel to MSSQL Insert operation
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.
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.