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 (;)
CochiseCountyAsked:
Who is Participating?
 
Scott PletcherConnect With a Mentor Senior DBACommented:
You can use semi-colon, so there must be some other issue.

Verify the contents of the file match the table exactly.

And please post the specific error, that would help a lot.
0
 
jdlambert1Commented:
1. What's the error message?
2. Have you tried other field terminators, like a vertical bar '|'?
0
 
CochiseCountyAuthor Commented:
You are right, I type the table's name wrong. It works now. Thanks
0
 
amit1978Commented:
U have to update registry to use semicolan insted of ','

If still having a problem please let us know
0
Question has a verified solution.

Are you are experiencing a similar issue? Get a personalized answer when you ask a related question.

Have a better answer? Share it in a comment.

All Courses

From novice to tech pro — start learning today.