I am trying to load CSV having 1 million records , but it stopes at 7 lacs , And my CSV is delimited by ~ .
I have tried many way to handle this issue by Qoutes none and ingnore end of file like that options , but when i am using it it is loading more than 1 million records.
I think you should look at the data within an editor like notepad ++ to see which character are really there then like Peter mentioned you will very probably have more delimiters as the "~" char.
An a small example will be really helpful - for 10/20 records you could manually scramble the data (I know it's an ugly job).
I agree with Marcus, you should verify also which characters do you have as end of line (carriage return and/or line feed), if this is misinterpreted by QV you will end up loading more records than you have.
