Export Data Into MS Excel

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.

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.

Thanks John.