First thing to do is get a copy of Alex Tweedly's excellent handler for
unpacking csv files.
After that, a lot depends on the structure of your database versus the
structure of the csv file but in general you just need to create a SQL
INSERT statement for each line in the csv file (except the head
Good evening everybody,
I have a text file that I need to import into a sqlite file. I have a
script that will create the sqlite file, however I am struggling with the
rest of the coding.
The text files comes with file headers that I can use, if I choose to.
Any help is greatly appreciated!
SK