How do i export data from sql statements to excel sheet in vb.net?

Question

THANKS!

Answer 1

One of two ways:

1. Shell Excel using OLE automation, and accessing Excel's object library create a worksheet and insert the data into cell(row, column)

2. Open an existing Excel worksheet (would have to preexist) as an OleDbConnection data source, and then add each row of data with an appropriate INSERT statement using an OleDbCommand object with the open OleDbConnection.