Batch to export SQL script output to excelt flat file

Toad for Oracle & DevOps Toolkit
1

Hi dear member,

Does it possible to create a windows command to export data set of SQL query to Excell file in Toad for Oracle 12.7.1.11 Basi Edition?

Kind regards

Leszek B.

2

Yes. Look in Toad’s Automation Designer. We have an “Export Dataset” action that can export to a variety of formats, including Excel. Once you have created an action there, you can run it from command line. To read about that, go to help. Under search, type in “Command line”. There is an entry in there called “Execute actions from the command line” that should help. Read that, and if you still have specific questions, post them here and we’ll help you.

3

Hi John,

I checked your advices and they works. Thank you very much for your help.

4

Hi John,

I thank you very much for your help that is useful for me.

5

Hi Leszek,

You’re welcome.

-John

6

Is there a way to break up a data set export into multiple files?

7

Sorry, there is no option for that. All rows are exported to the same file. The only thing close to that, is if you export to Excel, and you export more rows than Excel allows in a single sheet, then we create extra sheets as needed

However, there are ways to split a large text file with powershell. This may help: How can I split a text file using PowerShell? - Stack Overflow