Want to export data from SQL query to Excel

See more:

VB

Hi Everyone,

I am trying to export from sql query to excel as shown below

Dim mstrExcelQuery As String
            Dim commExcel As New SqlCommand
            conn = New SqlConnection("Data Source=MIL-Dev2-PC;Initial Catalog=meridian;User Id=sa;Password=master")
            conn.Open()
            mstrExcelQuery = "SELECT * INTO [Excel 8.0;DATABASE=" & strExcelFile & _
                     "].[" & strWorksheet & "] FROM " & "[" & FinalQuery & "]"
            commExcel = New SqlCommand(mstrExcelQuery, conn)
            commExcel.ExecuteNonQuery()
            commExcel.Dispose()
            conn.Close()
            SaveFileDialog1.Dispose()
            MsgBox("Report Saved to Excel!!", MsgBoxStyle.Information)

My strExcelfile=C:\Users\MIL-DEV2\Desktop\ExportExcel.xls

strWorkSheet=Rpt

mstrExcelQuery = Select * from TransactionMaster where CustomerName='Deepak'


But here I am getting an error "Invalid object name 'Select * from TransactionMaster where CustomerName='Deepak''"


ANy help is kindly appreciated