MicrosoftSqlServer2005导入导出语句集锦..pdfVIP

/******* 导出到 excel EXECmaster..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=Excel 5.0’)...xactions SELECTcast(cast(科目编号 as numeric(10,2)) as nvarchar(255))+ ’ ’ 转换后的别名 FROM OpenDataSource( ’Microsoft.Jet.OLEDB.4.0 ’, ’Data Source=c:test.xls;User ID=Admin;Password=;Extended properties=Excel 5.0’)...xactions /** 导入文本文件 EXECmaster..xp_cmdshell ’