1 select 2 --case (isnumeric(CMF_No)) when 1 then Convert(decimal(18,0),CMF_No) 3 --else Convert(nvarchar(255),CMF_No) end as CMF_No,Disti_Name, 4 --case (isnumeric(Disti_Invoice_Num)) when 1 then Convert(decimal(18,0),Disti_Invoice_Num) else 'sss' end as Disti_Invoice_Num, 5 case when len(Disti_Invoice_Num)<=1 then null when isnumeric(Disti_Invoice_Num) = 1 then Convert(decimal(18,0),Disti_Invoice_Num) else Convert(nvarchar(255),Disti_Invoice_Num) 6 end as 'Disti_Invoice_Num', 7 Disti_Invoice_Date,Scan_Date,Bar_Code,Product_Code, 8 case (isnumeric(Channel_GID_Num)) when 1 then Convert(decimal(18,0),Channel_GID_Num) else Convert(nvarchar(255),Channel_GID_Num) end as Channel_GID_Num, 9 Channel_Name,Channel_Address 10 11 from OpenDataSource ('Microsoft.ACE.OLEDB.12.0','Data Source=C:InetpubwwwrootDataSynchronizationDownData2016914164711677.xls;Extended properties=Excel 12.0')...[Sheet1$];