专注于互联网--专注于架构

最新标签
网站地图
文章索引
Rss订阅
导出到excel EXEC master..xp_cmdshell 'bcp SettleDB.dbo.shanghu out c:\temp1.xls -c -q -S"GNETDATA/GNETDATA" -U"sa" -P""'导入Excel SELECT * FROM OpenDataSource( 'Microsoft.Jet.OLEDB.4.0', 'Data Source="c:\test.xls";User ID=Admin;Password=;Extended properties=Excel 5.0')...xactions 动态文件名 declare @fn [阅读全文] [PDF]
******* 导出到excelEXEC master..xp_cmdshell \'bcp SettleDB.dbo.shanghu out c:\\temp1.xls -c -q -S\"GNETDATA/GNETDATA\" -U\"sa\" -P\"\"\' /*********** 导入ExcelSELECT * FROM OpenDataSource( \'Microsoft.Jet.OLEDB.4.0\',\'Data Source=\"c: [阅读全文] [PDF]
/* 导出到excelEXEC master..xp_cmdshell \'bcp SettleDB.dbo.shanghu out c:\\temp1.xls -c -q -S\"GNETDATA/GNETDATA\" -U\"sa\" -P\"\"\'/* 导入ExcelSELECT * FROM OpenDataSource( \'Microsoft.Jet.OLEDB.4.0\', \'Data Source=\"c:\\test.xls\";User I [阅读全文] [PDF]
/******* 导出到excelEXEC master..xp_cmdshell \'bcp SettleDB.dbo.shanghu out c:\\temp1.xls -c -q -S\"GNETDATA/GNETDATA\" -U\"sa\" -P\"\"\'/*********** 导入ExcelSELECT * FROM OpenDataSource( \'Microsoft.Jet.OLEDB.4.0\', \'Data Source=\"c:\\t [阅读全文] [PDF]
1 共4条 分1页