Hi experts, I have a file to import in SQL server 2000 ( about 7mb) and i get this error:
Too many columns found in current row, non white space character found after last default data..
how do i debug through this and look for what part is importing bad data? and is this mostly an error with special characters, or too many fields..?
attached is the file if anyone is interested to take a look...thank you in advance. demand.txt