This topic has been archived. It cannot be replied.
-
枫下家园 / 电脑用户 / how to use "load" command in SQL2000, Thanks in advancethe command below is wrong, how to correct it and load the data from that file into the table
load from "c:\aaa" insert into aaa_table delimiter "\"
thanks
-oceandeep(鱼划水);
2002-8-13
{171}
(#689344@0)
-
help!!!
-oceandeep(鱼划水);
2002-8-13
(#689365@0)
-
BULK INSERT aaa_table FROM 'c:\aaa'
WITH (
FIELDTERMINATOR = '\'
)
-yangn(Raymond);
2002-8-13
(#689366@0)
-
thanks,but i still want to add a row terminator,could u tell me how to write it
-oceandeep(鱼划水);
2002-8-13
(#689416@0)
-
by default the row terminator is '\n', but you still can put whatever you want into the bulkinsert statement:
BULK INSERT aaa_table FROM 'c:\aaa' WITH ( FIELDTERMINATOR = '\' ,
ROWTERMINATOR = '\n')
-yangn(Raymond);
2002-8-13
(#689429@0)