create table tbl_BulkUpload([id] [numeric](18, 0) IDENTITY(1,1) NOT NULL,
[EmpName] [nvarchar](max) NULL,
[LastName] [nvarchar](max) NULL,
[Email] [nvarchar](max) NULL
) ON [PRIMARY]
create view tbl_View_BulkUpload
as
select EmpName,LastName from tbl_BulkUpload
BULK INSERT tbl_View_BulkUpload
FROM 'D:\BulkUpload.txt'
WITH
(
FIELDTERMINATOR =',',
ROWTERMINATOR = '\n'
)