CochiseCounty
asked on
FIELDTERMINATOR
I have this code
BULK INSERT tmpStList FROM 'c:\TxtFile2.txt' WITH (FIELDTERMINATOR = ',')
It works fine. But when I change the ',' to ';' it give an error message. My text file is separated with semicolon (;)
BULK INSERT tmpStList FROM 'c:\TxtFile2.txt' WITH (FIELDTERMINATOR = ',')
It works fine. But when I change the ',' to ';' it give an error message. My text file is separated with semicolon (;)
ASKER CERTIFIED SOLUTION
membership
This solution is only available to members.
To access this solution, you must be a member of Experts Exchange.
ASKER
You are right, I type the table's name wrong. It works now. Thanks
U have to update registry to use semicolan insted of ','
If still having a problem please let us know
If still having a problem please let us know
2. Have you tried other field terminators, like a vertical bar '|'?