Re: Import text file into sqlite

2014-06-03 Thread Peter Haworth
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

Import text file into sqlite

2014-06-02 Thread Magicgate Software - Skip Kimpel
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