Export records to excel from sql

[padmanabhan N]

Dear friends, I need to export records from sql to excel. I know how to export the whole record to excel. But my requirement is, i have to insert 10 records in sheet1 and another 10 records in sheet2 and so on.... a help or some links would be highly appriciated..... (i dont want any packages like DTS)

Padmanabhan My Articles: Articles[^] My latest Article: Word Automation[^]

[T2102]

The only direct way I know how to do that with separate sheets is with ADO and COM.

[dan sh]

Check this[^]. I think this should help you.

50-50-90 rule: Anytime I have a 50-50 chance of getting something right, there's a 90% probability I'll get it wrong...!!

[gg4237]

Hi, if you are also interested in commercial solutions, check out GemBox.Spreadsheet .NET Excel component. With it you can easily do chunked exports to Excel, or export DataTable to Excel.