Named excel tabs for multi query export

[jake]

Is there a way to do it?

Right now when I export a few queries into Excel it names the tabs "Select table_name".

Thanks,
jake

 

[Marco Kalter]

You can set a tab name by using the tab= directive in a comment preceding the statement:

 

[jake]

Woohoo!!!!

You are my hero! That is going to save me a bunch of time.

...and I love the program. Been using it for 7+ years.

/jake

 

[uros.r.d]

Hello!

I can't generate excel file with multiple tab's. Did i missed something?

Uros

 

[Marco Kalter]

Execute multiple queries in the SQL Window, separated by semi-colons, right-click on a result set and select "Export to Excel > All as xls(x)".