insert into student select * from OPENROWSET('MICROSOFT.JET.OLEDB.4.0','Excel 5.0;HDR=YES;DATABASE=c:\student.xls',sheet1$)
注意:c:\student.xls的第一行为要导入sql表student的字段名
Copyright @ 2024 ms_dos Powered by .NET 9.0 on Kubernetes Powered by: .Text and ASP.NET Theme by: .NET Monster