|
Solution |
| You can
import data from Excel using pre-defined automation
template. See Solution - A. Alternatively, you
can use record feature as well. See Solution - B.
|
|
Solution - A
|
| 1. |
Use Data Transfer Template |
Click Tools->Templates and select
the Data Transfer template category. From this select
a template "Transfer data from Excel" and follow
the wizard. Screenshot
1 |
|
OR Solution - B
|
| 1. |
Create new task |
Click Tools -> Task Editor. |
| 2. |
Insert keystroke commands |
Record a task to copy one record
from Excel (Ctrl+C) and paste (Ctrl+V) to Access.
Use Keystroke commands instead of mouse. At the
end of copy use keyboard keys to move the active
cell in Excel and Access to Next record.
Screenshot 2 |
| 3. |
Insert Loop around
the keystrokes |
Place these keystroke commands inside
the Loop Block and set the number of times as number
of records to copy. |
| |
| When
you run this task, it will copy your excel records
to access file. To copy to Excel from Any Windows
application just follow the same process. |
Automation Anywhere - The Automation Software
