SQL数据库中存在一个Hotel_Gz表,其中有4个字段,分别是ID,Logtime,Mobile,
GZContent。里面ID是递增的,Logtime是默认getdate(),我想把新的数据(就2列:手机号码和工资条)从excel表导入Hotel_Gz表,脚本如下:
insert into Hotel_Gz
select 手机号码 as Mobile,工资条 as GZContent,
from openrowset( 'MICROSOFT.JET.OLEDB.4.0 ', 'EXCEL 5.0;HDR=YES;DATABASE=E:/audit/工资.XLS ',
[工资整理表$])
Modified:
insert into Hotel_Gz(Mobile,GZContent)
select 手机号码 as Mobile,工资条 as GZContent,
from openrowset( 'MICROSOFT.JET.OLEDB.4.0 ', 'EXCEL 5.0;HDR=YES;DATABASE=E:/audit/工资.XLS ',
[工资整理表$])