Click here to Skip to main content
16,020,313 members
Please Sign up or sign in to vote.
1.00/5 (2 votes)
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

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 :)
 
Share this answer
 

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



CodeProject, 20 Bay Street, 11th Floor Toronto, Ontario, Canada M5J 2N8 +1 (416) 849-8900