How to import data from database to excell?
|
1.
|
Create new task | Click on New -> Task Editor. |
|
2.
|
Connect to the database | Using the Database command from the Application category specify a connection string to connect to the Database Screenshot 1.
Connect to ' |
|
3.
|
Specify a SQL Query to get the data from database |
Using the Database command from the Application category and selecting SQL Query Option specify a SQL Query Execute SQL Statement: Select * From OrderMaster Where OrderDate $UserOpeator$ #$UserValue$# $UserOperator$: It is a variable which is accepted by the user through the Prompt command. $UserValue$: It is a variable which is accepted by the user through the Prompt command |
|
4.
|
Loop through all the rows of dataset | Using the Loop command and selecting "Each row in a SQL Query Dataset" option, you can Loop through each row of the result returned by the query.
Inside the Loop Block, specify the Keystroke to paste the values of each column of the Dataset using the variable $Dataset Column(1)$ in excel cells. Keystrokes: $Dataset Column(1) Note: To access values of different columns in the dataset use the index 1,2,3 etc with the System Variable $Dataset Column$. Also specify the Keystroke command to move to the next cell in the Excel sheet Keystrokes: [RIGHT ARROW] (Screenshot 2). |
| When you run this task, it connects to the database , retrieves a dataset & fills the cells of excel file with data fetched from database.
This tutorial demonstrates use of one of very powerful feature, 'Database' applications. Use this when you want to perform a task based on the data from any database. |
||
Screenshot 1:
Screenshot 2:
Windows media player 12
With it, you can play audio, video and viewing images on Windows 7 and have a great experience.
Norton Internet Security 2010
Norton Internet Security 2010 offers comprehensive protection against all types of online threats.
WinRAR 3.9
WinRAR is an powerful archiving utility that completely supports RAR and ZIP archives.
Senuti for Mac
Use Senuti to quickly and easily transfer music from your iPod or iPhone to your Mac.
VLC Media Player for Mac
VLC for Mac OS X is distributed as a disk image. Download the .dmg file, open it, and copy VLC to your hard drive.
iSquint
iSquint a program for converting videos from the internet to iPod or TV.
Tags:Automation Anywhere, database to excell, automation software, automation software for it, automation for business
Top Reviews
on Web Developer
Adobe Flash Player - SWF Player"Cross-platform flash video plug-in for web browsers to deliver users wonderful visual effects."
by Owen Wilson on Sep 7, 2009
Flash Gallery Builder"Flash Gallery Builder Reviews & Free Download"
by Heren Watson on Jan 10, 2008
