Importing ASCII data into SQL database
Posted on 2014-01-08
I am importing an ASCII text file into a SQL database.
I have a problem with text-lines in the ASCII file containing special characters.
If a line of text contains a special character (for example in the name / surname) it effects the formatting of that line, and imports incorrectly into the SQL database.
I believe the problem is with the reading of the actual ASCII text file, and the column count. The special characters seem to move the columns for that line, one or two characters forward.
Is there way of resolving this particular problem?