想要将数据从SQL查询导出到Excel [英] Want to export data from SQL query to Excel

问题描述

大家好，

我正在尝试从sql查询导出到excel，如下所示

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)

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

strWorkSheet = Rpt

mstrExcelQuery =从TransactionMaster中选择*，其中CustomerName =''Deepak''


但是在这里，我收到错误消息无效的对象名称"从TransactionMaster中选择*，其中CustomerName ="Deepak''''"


非常感谢您的帮助

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

推荐答案

尝试在此处查看-您的语法看起来有误: ^ ]

Try having a look here - Your syntax looks wrong: http://geekswithblogs.net/nagendraprasad/archive/2009/03/26/export-sql-server-data-into-excel.aspx[^]

选中此选项将对您有所帮助

使用VB.Net导出到Excel [

Check this it will help you

Export to Excel using VB.Net[^]

请参阅这些链接
在vb中将sql导出到excel [使用VB.Net导出到Excel [

hi refer these links
Export sql to excel in vb [^]

Export to Excel using VB.Net[^]

这篇关于想要将数据从SQL查询导出到Excel的文章就介绍到这了，希望我们推荐的答案对大家有所帮助，也希望大家多多支持IT屋！