Make SQLite/MySQL database using text

[Apostle]

Hi All,
I have text file and want to make script to insert it in database. The text looks like this (Sample line):

01O 1 1 Hapo mwanzo Mungu aliziumba mbingu na nchi.

The text is tab delimited.
Thanks alot!

[bvdet]

Here's an example:

import MySQLdb
db = MySQLdb.connect(passwd="something",db="whatever")
c = db.cursor()
c.execute(
    """INSERT INTO tablename (First_Name,Middle_Name,Last_Name,Month,Day,
    Year,Gender,Address,City,Pin,State,Phone)
    VALUES (%s, %s, %s, %s, %s, %s, %s, %s, %s, %s, %s, %s, %s)""",
    (fn,mn,ln,month,day,year,gender,add,city,pin,state,phone))

To get your data into a list:

>>> s = "01O\t1\t1\tHapo\tmwanzo\tMungu\taliziumba\tmbingu\tna\tnchi"
>>> s.split()
['01O', '1', '1', 'Hapo', 'mwanzo', 'Mungu', 'aliziumba', 'mbingu', 'na', 'nchi']
>>>

[Apostle]

thanks alot
I love the simplicity