sql server 2008 导入导出数据大全

sqlserver2008导入导出数据大全/******* 导出到excelEXECmaster..xp_cmdshell'bcpSettleDB.dbo.shanghuoutc:\temp1.xls-c-q-S"GNETDATA/GNETDATA"-U"sa"-P""'/*********** 导入ExcelSELECT*FROMOpenDataSource('Microsoft.Jet.OLEDB.4.0', 'DataSource="c:\test.xls";UserID=A