The data import procedure acts on standard row/column separators even when they are enclosed in quotes.
For instance, if a text field enclosed in quotes includes a carriage return, it is treated as the end of the row and the rest of the column after the carriage return is treated as the first column in the next row, thus causing any errors on the import.
Same thing happens if the specified separator character is found in a text field enclosed in quotes, such as a semi-colon or a comma.
This is the international (english) support forum for the SQLite Administrator developed and maintained by Orbmu2k.
1 post • Page 1 of 1
Who is online
Users browsing this forum: No registered users and 1 guest