mssql-excel数据导入添加

广告：

INSERT INTO eaddress
(userid, ename, company, part,email,adddate)
SELECT 'zhangpei' AS Expr1, 联系人,公司名, 部门,邮箱,GETDATE() AS Expr2
FROM zhangpei.dbo.Sheet1$ where 邮箱 is not null and 邮箱<>''

INSERT INTO eaddress
(userid, ename, company, part, email,adddate)
SELECT 'liaohuayan' AS Expr1, 联系人, 公司名, 部门, 公司邮箱地址,GETDATE() AS Expr2
FROM liaohuayan.dbo.Sheet1$ where 公司邮箱地址 is not null and 公司邮箱地址<>''

广告：