YAN HONG YE wrote:
I have a txt file
myteam.txt:
ID;name;sex;match;chinese;english;phy;chem;total
CY001;cred;male;54;101;101;55;99;695
CY002;rose;female;55;105;95;119;101;693
CY003;helen;male;110;95;65;50;50;613
CY004;jack;female;55;65;110;51;50;641
CY005;tonny;male;55;55;111;55;55;514
when I import the txt to my sqlite table, could I import the the first row
contains columnnames, not data.
like odbc "HDR=Yes"
I created a modified version of the SQLite3 shell which, among other
features, acts as you suggest when a .import command is issued while
headers are enabled. It can be found at:
https://docs.google.com/viewer?a=v&pid=explorer&chrome=true&srcid=0BzRwojdN0G2UMWY2MTg2NzgtNDU3YS00Y2RiLWI5MTktMDZiMDYxZGU5MGEx&hl=en_US&pli=1
(Watch line wrap -- that's a one line URL.)
Cheers,
--
Larry Brasfield
_______________________________________________
sqlite-users mailing list
[email protected]
http://sqlite.org:8080/cgi-bin/mailman/listinfo/sqlite-users
