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.
See the Bot in Action
Download the Bot and follow the instructions to install it in your AAE Control Room.
Open the Bot to configure your username and other settings the Bot will need (see the Installation Guide or ReadMe for details.)
That's it - now the Bot is ready to get going!
Requirements and Inputs
- -AAE 11.1.2 or above.
-MS Office and ODBC/OleDB drivers.
Inputs: 1. Table Name - Database Table Name 2. Sheet Name - Excel Sheet Name 3. hdrExist - YES/NO 4. Excel File Path 5. ODBC Connection String 6. DB Host 7. Database 8. DB User Id 9. DB Password