I have an excel file which I need to import on a regular basis. At the moment I right click on the table and run the import wizard. Is there a way to automate this so it can be run from a .bat script?
I would recommend using the Automation Designer and the Import Table Data action. You can schedule it to run whenever you want within there. There’s plenty
of information on Help and Toad World to help you get started with AD.
From: brian_1438 [mailto:bounce-brian_1438@toadworld.com]
Sent: Thursday, December 18, 2014 11:17 PM
Subject: [Toad for Oracle - Discussion Forum] Import via command line
Thread created by brian_1438
I have an excel file which I need to import on a regular basis. At the moment I right click on the table and run the import wizard. Is there a way to automate this
so it can be run from a .bat script?
To reply, please reply-all to this email.
Stop receiving emails on this subject.
Or
Unsubscribe from Toad for Oracle - General notifications altogether.
Toad for Oracle - Discussion Forum
Flag
this post as spam/abuse.
Thank you. The Automation Designer is a very nice tool.