How can I import data into existing tables? It is possible to automate this?
You can use Toad for Oracle to make importing data for existing tables much easier. In addition, the Import Table Data Wizard can be programmed as an Action, so repeating imports with the same settings can be as easy as clicking a button.
Review this solution for a tutorial video and other instructions on how to use the Automation Designer to create actions.