Dear Friends
I want to write a program in order to insert data to a sqlite database from a
text file. The text file contains data in each line as below which repeats
about 200 lines:
P05075
01-JAN-1988
16
TOBACCO RATTLE VIRUS (STRAIN PSG).
CORNELISSEN B.J.C., LINTHORST H.J.M., BREDERODE F.T., BOL J.F.;
NUCL. ACIDS RES. 14:2157-2169(1986).
141
16297
93420
MTCVLKGCVNEVTVLGHETCSIGHANKLRKQVADMVGVTRRCAENNCGWFVCIIINDFTFDVYNCCGRSHLEKCRKRVEARNREIWKQIRRIQAESSSATRKKSHNSKNSKKKFKEDREFGAPKRFLRDDVPLGIDQLFVF
...
I want to read this file and insert each line into a value of a database
(database contains 3 tables). I can write a code to read text file but I do not
know how to insert these data to sqlite tables during reading process. Could
any one suggest me a simple program to do this?
Thanks for your helps.
Best regards
Yazdan
_______________________________________________
sqlite-users mailing list
sqlite-users@sqlite.org
http://sqlite.org:8080/cgi-bin/mailman/listinfo/sqlite-users
