Insert data from excel to database

最新推荐文章于 2024-01-26 13:54:33 发布

weixin_30852367

最新推荐文章于 2024-01-26 13:54:33 发布

阅读量116

点赞数

文章标签：数据库

原文链接：http://www.cnblogs.com/Elsie/p/3267404.html

版权


USE  ESPA

Truncate table dbo.Interface_Customer
--Delete the table data but retain the structure

exec sp_configure "show advanced options",1
reconfigure
go
exec sp_configure "Ad Hoc Distributed Queries",1
reconfigure 
go
--Open peripheral component and service related to data imput and export



INSERT INTO Interface_Customer  (Cust_Code,Cust_Name, Src_Sys_Code,Currency,Customer_group)  
SELECT  
Cust_Code,
[Cust_Name ( Chinese)],
Src_Sys_Code,
Currency,
[Customer group]
from  OPENDATASOURCE 
('Microsoft.ACE.OLEDB.12.0','Data Source="E:\eSPA_database\eSpa2_Test_data-Product.xls";Extended properties=Excel 8.0')...sheet1$
--Insert data from excel to database 


exec sp_configure "Ad Hoc Distributed Queries",0
reconfigure
go
exec sp_configure "show advanced options",0
reconfigure
go

贴在这里，图个方便

转载于:https://www.cnblogs.com/Elsie/p/3267404.html