use espatruncate table dbo.interface_customer--delete the table data but retain the structureexec sp_configure show advanced options,1reconfiguregoexec sp_configure ad hoc distributed queries,1reconfigure go--open peripheral component
use espatruncate table dbo.interface_customer--delete the table data but retain the structureexec sp_configure show advanced options,1reconfiguregoexec sp_configure ad hoc distributed queries,1reconfigure go--open peripheral component and service related to data imput and exportinsert 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 databaseexec sp_configure ad hoc distributed queries,0reconfiguregoexec sp_configure show advanced options,0reconfigurego，免备案空间，网站空间，美国服务器