Excel 这种要求的SELECT语句怎样写
发布网友
发布时间:2022-04-28 11:27
我来回答
共1个回答
热心网友
时间:2023-10-05 10:41
--Excel2003
INSERT INTO OPENROWSET('Microsoft.Jet.OleDb.4.0','Excel 8.0;DATABASE=D:\Excel文件名.xls','SELECT 字段1,字段2 FROM [Sheet1$]')
SELECT top 20 字段1,字段2 FROM student
--Excel2007
INSERT INTO OPENROWSET('Microsoft.Ace.OleDb.12.0','Excel 12.0;DATABASE=D:\Excel文件名.xlsx','SELECT 字段1,字段2 FROM [Sheet1$]')
SELECT top 20 字段1,字段2 FROM student
热心网友
时间:2023-10-05 10:41
--Excel2003
INSERT INTO OPENROWSET('Microsoft.Jet.OleDb.4.0','Excel 8.0;DATABASE=D:\Excel文件名.xls','SELECT 字段1,字段2 FROM [Sheet1$]')
SELECT top 20 字段1,字段2 FROM student
--Excel2007
INSERT INTO OPENROWSET('Microsoft.Ace.OleDb.12.0','Excel 12.0;DATABASE=D:\Excel文件名.xlsx','SELECT 字段1,字段2 FROM [Sheet1$]')
SELECT top 20 字段1,字段2 FROM student