Earlier I posted a snippet which showed how to create a 2 dimensional string array from an SQLite database table.
This snippet is the reverse, if you will, where we create an SQLite database table from a 2d string array.
It should be noted that this code has it's limitations, as is, and should be used where the strings in array are less than 128 characters long. This can easily be amended to accommodate strings of any length, but I felt it was beyond the scope of this snippet.
This code demonstrates one way to create a transaction which greatly speeds up table insertion where many single queries might otherwise be used.
TrimRight
is just a little helper method which trims n characters from right side of string.
Once again, any comments, critisisms or improvement suggestions are very welcome.