Toad World® Forums

Export Data Into MS Excel


#1

I am impressed by Toad’s ability to export a large number of rows to Excel i.e. in excess of 150, 000, with no problems.

My question is: Can this be reproduced programmatically in code (e.g. using C# and a Toad API that exposes the functionality)?

This will be a massive help as other API frameworks have failed with out of memory exceptions.

Thanks in advance.


#2

We don’t have an API, but you can use Toad’s automation Designer to set up your export, and then call it from a command prompt. Look in the help’s index under “Command line, actions” for details.


#3

Thanks John.