| 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
