Re: [sqlite] Easyer way ?

[Reid Thompson]

Puneet Kishor wrote:


You will need to type the values at least once to convert from paper 
to bits, but you need not type in the INSERT command. Type them in 
Excel, or in a text editor... save the file as a CSV file, then load 
the file in SQLite (I believe there is a command to load CSV... if 
not, use the editor's capability to add the INSERT INTO car bit with 
the correct parens and quotes, etc.).

Make sure to quote the text, and not the numbers. Make sure the values 
are in the same order as the columns, and you won't even have to name 
the columns.

Puneet Kishor

This is going to be your quickest way -- unless you have a VERY good OCR 
program that can give you a head start.