今天,一不小心把EXCEL数据上传到了SQL SERVER。
玉丰说,学会一技术要低调,不能让人知道是刚会的~~~~~~~~嘿嘿!!!
if (FileUpload1.HasFile) //如果用户确实选择了上传控件的浏览按钮,浏览文件成功.
{
this.FileUpload1.SaveAs("D:\\Temp\\" + FileUpload1.FileName); //保存到服务器的目录,需要根据服务器具体情况修改FileUpload1.FileName会自动获取上传文件名.
sdh.dbExecuteSql("insert into Larbor select * from OPENROWSET('MICROSOFT.JET.OLEDB.4.0' ,'Excel 8.0;hdr=yes;database=D:\\Temp\\" + FileUpload1.FileName + "',Sheet1$)");//Sheet1名为excel表当前页的名称.Larbor是接受表表名
Response.Write("<script>alert('导入成功!');</script>");
}
else
{
Response.Write("<script>alert('导入失败!');</script>");
}
{
this.FileUpload1.SaveAs("D:\\Temp\\" + FileUpload1.FileName); //保存到服务器的目录,需要根据服务器具体情况修改FileUpload1.FileName会自动获取上传文件名.
sdh.dbExecuteSql("insert into Larbor select * from OPENROWSET('MICROSOFT.JET.OLEDB.4.0' ,'Excel 8.0;hdr=yes;database=D:\\Temp\\" + FileUpload1.FileName + "',Sheet1$)");//Sheet1名为excel表当前页的名称.Larbor是接受表表名
Response.Write("<script>alert('导入成功!');</script>");
}
else
{
Response.Write("<script>alert('导入失败!');</script>");
}
SQL2005默认是没有开启Ad Hoc Distributed Queries 组件
数据库执行:
EXEC sp_configure show advanced options, 1
GO
RECONFIGURE
GO
EXEC sp_configure Ad Hoc Distributed Queries, 1
GO
RECONFIGURE
GO