Date: Thu, 01 Mar 2012 19:39:41 -0800 From: Larry Brasfield <larry_brasfi...@iinet.com> To: sqlite-users@sqlite.org Subject: Re: [sqlite] import a txt into sqlite Message-ID: <4f5040fd.3000...@iinet.com> Content-Type: text/plain; charset=ISO-8859-1; format=flowed
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 sqlite-users@sqlite.org http://sqlite.org:8080/cgi-bin/mailman/listinfo/sqlite-users