Click here to Skip to main content
14,365,441 members
Rate this:
Please Sign up or sign in to vote.
See more:
Please help me with the code to export data from sql server in multiple excel sheets
Posted
Comments
Pheonyx 4-Oct-13 10:26am
   
What have you tried?
Where are you stuck?
What sort of format do you want?
Are you processing it?
Is it a windows forms application/ WPF application / Web Application?

1 solution

Rate this:
Please Sign up or sign in to vote.

Solution 1

There are many ways to achieve this. You have to fetch data from your Database to DataTable or DataSet and then you can export it to Excel. Please refer below links to understand how to Export data from DataSet or DataTable.
http://www.authorcode.com/export-datatable-to-excel-in-vb-net/[^]
Export to Excel using VB.Net[^]
http://stackoverflow.com/questions/6108145/export-to-excel-using-vb-net-windows-app[^]
Exporting DataGrid to Excel, Word and Text Files[^]
I hope this will help you :)
   

This content, along with any associated source code and files, is licensed under The Code Project Open License (CPOL)




CodeProject, 503-250 Ferrand Drive Toronto Ontario, M3C 3G8 Canada +1 416-849-8900 x 100