Hi, I am having problems importing XML string into my table. 1, When I use BULK INSERT Northwind.dbo.xml_test FROM 'c:myfile.xml' WITH ( FIELDTERMINATOR = '|', ROWTERMINATOR = '| ' ) I get an error: Bulk Insert: Unexpected end-of-file (EOF) encountered in data file. 2, Tried to do the bcp with format file, no luck. 3. the textcopy sort of works, but truncates the string, so only part of it is imported. I use it so: TEXTCOPY /SmyServer /Usa /Psapass /DNorthwind /Txml_test /CtxtDocument /I /Fmyfile1.txt /W"WHERE iKey = 1" can someone helP?