Read Excel Data and update MSSQL Database

This bot reads data from input files and writes to a database. Connects to the database using database commands from Task console and writes to Db extracting  user input from Excel or CSV.

Top Benefits

  • Quick and Seamless Integration
  • Easy to use and integrate in new or existing tasks without any technical supervision
  • Easy to update the database with just one click.
This bot connects to your database and writes from Excel, CSV or from user input

The sample is already provided with the input query. Change or add values and variables according to your needs.

Key Use Case: Update your database from botsUpdate your database from bots

Setup process

Install

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

Configure

Use the Bot in a bot, configure keys and other credentials the Bot will need (see the ReadMe for details.)

Run

That's it - now the Bot is ready to get going!

Requirements and Inputs

  • Database: Microsoft SQL Server Management Studio Automation anywhere version 10.7 or above
  • Inputs: None

Customer Reviews

0.0(0 reviews)

No reviews yet.