I need to export data from SQL 2005 into Excel. I know I can use bcp or OPENSOURCE, but the requirement is that I need
to customise my excel: with titles of different sizes, company's logo, making various results bold and so.
I assume the best way to do so would be by creating an html or even xml file, but cannot find a proper example, so my questions are:
- what is the best way to create such an Excel file?
- can some one point me to a website I can have a look, or even post some basic example here, please?
Any suggestion will be much appreciated!