I am importing files originally created with Excel 2000 and saved as CSV. Most of my imports are fine, but one table skips a large number of rows. SQlite Mgr gives the message "failed to import 80 lines" and tells me exactly which lines of the CSV file were not imported. I cannot see anything wrong with the skipped lines, but they are in groups of 15 consecutive lines: 49-64, 161-176, 193-208, etc.
Strangely, I tried sorting the CSV file on a different column and the number of failed lines changes: "failed to import 96 lines". I am new to SQlite Manager. Any help would be appreciated.
If you would like to refer to this comment somewhere else in this project, copy and paste the following link:
I am importing files originally created with Excel 2000 and saved as CSV. Most of my imports are fine, but one table skips a large number of rows. SQlite Mgr gives the message "failed to import 80 lines" and tells me exactly which lines of the CSV file were not imported. I cannot see anything wrong with the skipped lines, but they are in groups of 15 consecutive lines: 49-64, 161-176, 193-208, etc.
Strangely, I tried sorting the CSV file on a different column and the number of failed lines changes: "failed to import 96 lines". I am new to SQlite Manager. Any help would be appreciated.
Problem solved by copying the data and pasting into a new Excel workbook.