i want select data from a txt file like this :
abajijola@yahoo.com
aball_of_fire2003@yahoo.com
abamo_bekhor@yahoo.com
aban_soraty@yahoo.com
aban_star@yahoo.com
aban8_2005@yahoo.com
abanabat@yahoo.com
abas_1jigar@yahoo.com
abas_4567@yahoo.com
abas_abase67@yahoo.com
abas_s_2005@yahoo.com
abas_shakib@yahoo.com
abasalt_tag@yahoo.com
abass_karimi2000@yahoo.com
abatgom@yahoo.com
abb.sea1@yahoo.com
and i whire this code in sql server
create table #tbl
(
email nvarchar(50)
)
bulk insert #tbl
from 'C:\Users\user\Desktop\eee\E.txt'
with
(
Rowterminator = '\n'
)
select * from #tbl
but give this error :
Msg 4864, Level 16, State 1, Line 5
Bulk load data conversion error (type mismatch or invalid character for the specified codepage) for row 54667, column 1 (email).
Msg 4864, Level 16, State 1, Line 5
Bulk load data conversion error (type mismatch or invalid character for the specified codepage) for row 54670, column 1 (email).
Msg 4864, Level 16, State 1, Line 5
Bulk load data conversion error (type mismatch or invalid character for the specified codepage) for row 54672, column 1 (email).
Msg 4864, Level 16, State 1, Line 5
Bulk load data conversion error (type mismatch or invalid character for the specified codepage) for row 54674, column 1 (email).
Msg 4864, Level 16, State 1, Line 5
Bulk load data conversion error (type mismatch or invalid character for the specified codepage) for row 54676, column 1 (email).
Msg 4864, Level 16, State 1, Line 5
Bulk load data conversion error (type mismatch or invalid character for the specified codepage) for row 54678, column 1 (email).
Msg 4864, Level 16, State 1, Line 5
Bulk load data conversion error (type mismatch or invalid character for the specified codepage) for row 54680, column 1 (email).
Msg 4864, Level 16, State 1, Line 5
Bulk load data conversion error (type mismatch or invalid character for the specified codepage) for row 55683, column 1 (email).
Msg 4864, Level 16, State 1, Line 5
Bulk load data conversion error (type mismatch or invalid character for the specified codepage) for row 55686, column 1 (email).
Msg 4864, Level 16, State 1, Line 5
Bulk load data conversion error (type mismatch or invalid character for the specified codepage) for row 55688, column 1 (email).
Msg 4864, Level 16, State 1, Line 5
Bulk load data conversion error (type mismatch or invalid character for the specified codepage) for row 55690, column 1 (email).
Msg 4865, Level 16, State 1, Line 5
Cannot bulk load because the maximum number of errors (10) was exceeded.
Msg 7399, Level 16, State 1, Line 5
The OLE DB provider "BULK" for linked server "(null)" reported an error. The provider did not give any information about the error.
Msg 7330, Level 16, State 2, Line 5
Cannot fetch a row from OLE DB provider "BULK" for linked server "(null)".