位置: sql导入和导出数据 - 标签
SQL语句导入导出大全(sql导入和导出数据)
简述:导出到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";Us
发布时间:2024/02/26
鄂ICP备2023003026号