importing csv file into sqlite

Chris Rebert clp at rebertia.com
Thu Dec 18 07:08:02 CET 2008


On Wed, Dec 17, 2008 at 9:58 PM, klia <alwaseem307ster at yahoo.com> wrote:
>
> hey guys, i have a hug .csv file which i need to insert it into sqlite
> database using python.
> my csv data looks like this
> Birthday2,12/5/2008,HTC,this is my birthday
> Sea,12/3/2008,kodak,sea
> birthday4,14/3/2009,samsung,birthday
> love,17/4/2009,SONY,view of island
>
> can any one give me a head start codes.
>

Use the `csv` module to read the CSV file:
http://docs.python.org/library/csv.html
I think one who knows sqlite can quite easily figure it out from there.

Cheers,
Chris

-- 
Follow the path of the Iguana...
http://rebertia.com



More information about the Python-list mailing list