sql导出到excel（SQL exported to excel）.docVIP

sql导出到excel（SQL exported to excel） SQL export to Excel.txt43 sails, not hanging on the mast, is a useless piece of cloth; the mast, dont hang up the sails, is a normal column; ideals into action is not action, with no reality whatever fog; but not ideal, is not only taking the end of the road. 44 often unlatched the door of success, as long as you are brave to push, it will suddenly open. SQL exported to Excel From the Excel file, importing data into the SQL database is simple, using the following statement directly: /*===================================================================*/ -- if you accept data, the import table already exists Insert into table select * from OPENROWSET (MICROSOFT.JET.OLEDB.4.0 Excel 5; HDR=YES; sheet1$; DATABASE=c:\test.xls) -- if you import data and generate tables Select * into table from OPENROWSET (MICROSOFT.JET.OLEDB.4.0 Excel 5; HDR=YES; sheet1$; DATABASE=c:\test.xls) /*===================================================================*/ - - if you export data from the SQL database to Excel, if the Excel file already exists and you have created a good header in the data you want to receive, you can simply use it: Insert into OPENROWSET (MICROSOFT.JET.OLEDB.4.0 Excel 5; HDR=YES; sheet1$; DATABASE=c:\test.xls) Select * from table - if the Excel file does not exist, you can also use BCP to guide the class Excel file. Note the case: -- exporting tables The EXEC master..Xp_cmdshellbcp database name,.Dbo. table name, out, c:\test.xls, /c, -/S, server name, /U, user name, -P, password -- exporting queries EXEC, master..Xp_cmdshell,bcp, SELECT, au_fname, au_lname, FROM, ORDER, BY, au_lname, queryout, c:\test.xls, /c, -/S, server name, /U, user name, -P, password pubs..Authors Explain. C:\test.xls is the import / export Excel file name Sheet1$is the worksheet name of the Excel file, typically $plus for normal use Here is a way to export a real Excel file: /*-- EXCEL export data Export the data from the table to Excel, which contains th