Re: Exporting a data set to Excel - can you make TOAD export different worksheets?

Excel Instance exports the data to and existing instance of Excel running on your machine, if on eexists. If not, it creates one.

I'm not sure what you mean by "different worksheets for each database". each export will create a new Worksheet in the selected Workbook (in the specified Excel document or currently running instance, depending on your selection).

I'm in no position to change Toad, but that's been my experience with how it works.

Sean

--- In [email protected], "Evelyn" <roxrox_1959@...> wrote:
>
> I would like to have one spreadsheet with different worksheets for each database.  I see there is an Excel Instance but it's unclear what it does.
>




------------------------------------

Yahoo! Groups Links

<*> To visit your group on the web, go to:
    http://groups.yahoo.com/group/toad/

<*> Your email settings:
    Individual Email | Traditional

<*> To change settings online go to:
    http://groups.yahoo.com/group/toad/join
    (Yahoo! ID required)

<*> To change settings via email:
    [email protected] 
    [email protected]

<*> To unsubscribe from this group, send an email to:
    [email protected]

<*> Your use of Yahoo! Groups is subject to:
    http://docs.yahoo.com/info/terms/