INSERT INTO mobile(number,Charges,category,Price) SELECT number
,Charges,category,Price FROM OPENROWSET('MICROSOFT.JET.OLEDB.4.0'
,'Excel 5.0;HDR=YES;DATABASE=E:\Book1.xls',sheet1$)
execl导入用sql导入到数据库中!!!!!
最新推荐文章于 2023-05-23 18:55:55 发布
INSERT INTO mobile(number,Charges,category,Price) SELECT number
,Charges,category,Price FROM OPENROWSET('MICROSOFT.JET.OLEDB.4.0'
,'Excel 5.0;HDR=YES;DATABASE=E:\Book1.xls',sheet1$)