Yes guys but even that technique is useless as it doesn't retain datatypes. What's the use of dumping the results in Excel if you have to spend time to reset all the columns formats datatypes?

The one technique a collegue of mine uses with success is : Go into SQL Management Studio, right click on database, all tasks, export data.

That will retains all datatypes and also headings.