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

  • 1. Achieving Best Performance of transferring data to Database 2. 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.

Get Bot

Free

Bot Security Program
Level 1
Applications
Business Process
Category
Downloads
252
Vendor
Automation Type
Bot
Last Updated
December 6, 2019
First Published
November 2, 2018
Support

See the Bot in Action

PREV NEXT

Setup Process

Install

Download the Bot and follow the instructions to install it in your AAE Control Room.

Configure

Open the Bot to configure your username and other settings the Bot will need (see the Installation Guide or ReadMe for details.)

Run

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