CSVDump | reliable tool for dumping CSV files | Database library

This is what I came up with. I split it into two files for easier debugging, but you could undo that if you want. This reads in each line, as soon as you encounter "Table2" then you break out of the loop. If the first column contains "N" then you are in the table header and you add the header, if not then add an empty field.

The amount of memory for Java code on Android is limited to something like 16 Mb (varies by device). So you either need to move this part to native NDK code, where you can malloc() as much memory as your device has, or save the file directly to disk, then process it without loading the whole file into Java buffers. Use URLConnection.getInputStream() or URLConnection.read() in a loop with a 16Kb byte array instead of copying the whole file into response array. Or you can read it line-by-line directly from the HTTP stream, using BufferedReader.readLine(), and fill your database line-by-line.

Try this :

Simply change the index in your Insert statement: