On 12/6/05, ronggui wong <[EMAIL PROTECTED]> wrote: > I have a very large CSV file with 10000 rows and 100 columns.and the > file looks like the following: > "a","b","c","d", > "1","2","1","3" , > "3","2","2","1", > ...... > > If I use .import,It seems I have to set the variable names manually . > Is there any way to import the whole data file into SQLite quickly?
Use vi, emacs, ed, or sed to change the data to insert statements. You'll be done in ten minutes and no programming is needed.
