INSERT INTO eStaff_Register(badge,name,EName,Last_Name,First_Name,CertNo,Passportnumber,BirthDay,Gender)
SELECT [工号] ,CAST([姓名] AS NVARCHAR(200)),CAST([英文名] AS NVARCHAR(200))
,CAST([英文名-姓] AS NVARCHAR(200)),CAST([英文名-名] AS NVARCHAR(200)),CAST([身份证号码] AS VARCHAR(200)),CAST([护照号码-外籍] AS varchar(200))
,CAST([生日] AS datetime),(CASE [性别] WHEN N'男' THEN 1 WHEN N'女'THEN 2 end)
FROM OPENDATASOURCE('Microsoft.Ace.OLEDB.12.0',
'Data Source=E:\test2.xlsx;Extended Properties=Excel 12.0')...基本信息$