Hi everyone. good nice for all of you.
I'm in a project including SQL export into excel file.
I have succeeded in exporting a table into 1 excel file . But, my project wasn't simple than that.
I need to export many table in sql server into a single excel file. ( not using vb, c# or any programming language )
is it posssible?
please help me
You can try SSIS which can export each table into a separate sheet of the excel file.
can you give me some articles about it.thank