hi
text file so
005283 BAK? BA? S?HIYY? IDAR?SI 2 100 00010130606 1000 000 000 000 000 1000 1
020200*AVIRTEL MMC 2 000 3803710 -200 000 000 000 000 -200 0
1--- I created a table
CREATE TABLE idare_abune
(Test char(6), Test1 char(60), Test2 char(2), Test3 char(4),
Test4 char(26), Test5 char(11), Test6 char(12),
Test7 char(8), Test8 char(7), Test9 char(7),
Test10 char(11), Test11 char(5), Test12 char(7),Test13 char(3))
2--------- I created a fmt file
exec xp_cmdshell
'bcp ats342.dbo.idare_abune format nul -S XIRDALAN-SERVER -f "c:\temp\idare_abun.fmt" -c -T'
3----------I changed fmt file
'\t' to ''
4----
BULK INSERT idare_abune
FROM 'C:\Documents and Settings\?????????????\??????? ????\obrabotka\OBOROTKA-092.list.txt'
WITH
(
FORMATFILE = 'c:\temp\idare_abun.fmt'
)
-----------------
i get error
-------
The statement has been terminated.