SQL语句导入导出大全..pdfVIP

EXEC master..xp_cmdshell bcp SettleDB.dbo.shanghu out c:\temp1.xls -c -q - SGNETDATA/GNETDATA -Usa -P /*********** 导入 Excel SELECT * FROM OpenDataSource( Microsoft.Jet.OLEDB.4.0, Data Source=c:\test.xls;User ID=Admin;Password=;Extended properties=Ex cel 5.0)...xactions /* 动态文件名 declare @fn varchar(20),@s varchar(1000) set @fn = c:\test.xls set @s =Microsoft.Jet.OLEDB.4.0, Data Source=+@fn+;User ID=Admin;Password=;Extended propertie