Honestly I am a bit confuse where to post this question, whether Excel Forum, SQL Server forum, or .NET forum.
I need to export certain table from SQL Server DB to an excel file, programmatically trigger from .NET. It means, at my application, I can select a few tables (let say 3 tables: customer, product, category) and when I click "Export to Excel"
button, it exports to an excel file with 3 different sheet according to the table I selected.
I know there are many way to achieve that as I find:
While those solution provids customizable solution from code, it also require quite lots of effort. Whereby, in my case, I don't need any customization, so
View Complete Post