Community discussion forum

How to write a query set to excel using vb.net

• • Reply

  26 days ago

  by anjorin

  Tola Anjorin

  Lagos, Nigeria

  Joined 26 days ago

  I have a challenge of writing a a query set to an excel sheet.

  I am using VB 2005 and SQL Server.

  Thanks,

  Post was edited on 02/11/2009 07:49:25 Report abuse
• • Reply

  22 days ago

  by BarbaMariolino

  Filip

  , Croatia (Hrvatska)

  Joined 1 year ago

  You can write Excel file in VB.NET with GemBox.Spreadsheet excel component.

  First you use ADO.NET to fill DataSet with data from SQL Server database, and then simply export DataSet to Excel.

  Report abuse