insert into OPENROWSET('Microsoft.Jet.OLEDB.4.0',
'Excel 8.0;Database=C:/Documents and Settings/Administrator/My Documents/active.xls;',
'SELECT * FROM [Sheet1$]') SELECT TOP 40 cus_id,cus_studyid FROM Edu_cus
sql数据导入excel中。
最新推荐文章于 2024-07-09 22:51:17 发布