I have a Form that I created in Visual Studio 2008that I want to use to execute a query on SQL Server then return the results back to Excel in a specific worksheet. Can this be done easily? I don't have much experience with VB .Net, I have done this in Access using the TransferSpreadSheet method but I am in the process of transfering everything to SQL Server and need to replicate.

If you get the data from SQL Server as a DataTable, you can write the DataTable to an Excel spreadsheet with the code shown here:

http://msmvps.com/blogs/deborahk/archive/2009/07/23/writing-data-from-a-datatable-to-excel.aspx

Hope this helps.

---

www.insteptech.com ; msmvps.com/blogs/deborahk
We are volunteers and ask only that if we are able to help you, that you mark our reply as your answer. THANKS!

If you get the data from SQL Server as a DataTable, you can write the DataTable to an Excel spreadsheet with the code shown here:

http://msmvps.com/blogs/deborahk/archive/2009/07/23/writing-data-from-a-datatable-to-excel.aspx

Hope this helps.

---

www.insteptech.com ; msmvps.com/blogs/deborahk
We are volunteers and ask only that if we are able to help you, that you mark our reply as your answer. THANKS!