从excel把数据导入到sqlserver里

aguai0

于 2010-09-27 17:38:16 发布

阅读量105

点赞数

本文链接：https://blog.youkuaiyun.com/aguai0/article/details/83724725

版权

本文介绍了如何通过SQL配置开启高级选项及分布式查询功能，并演示了从Excel文件中导入数据到SQL Server的具体步骤。

摘要生成于 C知道，由 DeepSeek-R1 满血版支持，前往体验 >

1、exec sp_configure 'show advanced options',1
reconfigure

exec sp_configure 'Ad Hoc Distributed Queries',1
reconfigure

2、insert into lyframe.TL_HEATING_INFO (HEATING_ID,HEATING_NAME,ADDRESS,HEATING_PERSON,HEATING_PHONE,
DUTY_PHONE,OTHER_NAME,OTHER_PHONE,OTH_PHONE,HOUSE_NAME,DELETE_FLAG,CREATE_LOGONNAME)
SELECT HEATING_ID,HEATING_NAME,ADDRESS,HEATING_PERSON,HEATING_PHONE,DUTY_PHONE,OTHER_NAME,OTHER_PHONE,OTH_PHONE,HOUSE_NAME,DELETE_FLAG,CREATE_LOGONNAME FROM
OPENROWSET('Microsoft.ACE.OLEDB.12.0' --for excel 2007
,'Excel 5.0;HDR=YES;DATABASE=c:\1.xlsx',Sheet1$) AS TL_HEATING_INFO

3、exec sp_configure 'show advanced options',1
reconfigure

exec sp_configure 'Ad Hoc Distributed Queries',1
reconfigure;