数据导入问题

Question

怎样把txt文件导入sql_server表中
下面是txt文件的部分内容
"00026390104","数学过程动力学（高等师范院校数学系列教材）","","鲍  曼著","","哈工大","平装","大32开","7560317545","","","","14.8","1-1","020600","","","0184-0228"
"00026390112","中学数学方法论（高等师范院校数学系列教材）","","鲍  曼编著","","哈工大","平装","大32开","7560317529","","","","14.8","1-1","020600","","","0178-0220"
"00026390120","中学数学教学论（高等师范院校数学系列教材）","","濮安山编著","","哈工大","平装","大32开","7560317510","","","","16.8","1-1","020600","","","0231-0284"
"00026390138","经济数学基础及应用","","赵  萍编著","","哈工大","平装","16开","7560318061","","","","23.8","1-1","030100","","","0378-0312"
"00026390146","常微分方程","","王兴涛编","","哈工大","平装","大32开","7560318053","","","","11.8","1-1","030300","","","0200-0248"
"00026390153","物理化学实验","","夏海涛主编","","哈工大","平装","16开","7560318533","","","","26","1-1","030500","","","0480-0300"
"00026390161","基础化学信息学","","李  欣著","","哈工大","平装","16开","7560318312","","","","19","1-1","030300","","","0350-0237"
"00026390179","有机化学（工科基础化学系列丛书）","","宋兆成编著","","哈工大","平装","16开","7560317901","","","","28","1-1","030200","","","0576-0380"
"00026390187","简明塑料大全","","邢玉清编","译","哈工大","平装","16开","7560317693","","","","38","1-1","020900","","","0695-0524"

Answer 1

简单的方法：创建一个TStrings对象（例如：lstTemp），然后用他的LoadFromFile方法将Text导入到这个对象中（就是一个字符串列表），然后得到
lstTemp[0] ==> "00026390104","数学过程动力学（高等师范院校数学系列教材）","","鲍  曼著","","哈工大","平装","大32开","7560317545","","","","14.8","1-1","020600","","","0184-0228"
lstTemp[1] ==> "00026390112","中学数学方法论（高等师范院校数学系列教材）","","鲍  曼编著","","哈工大","平装","大32开","7560317529","","","","14.8","1-1","020600","","","0178-0220"
…………………………
然后在分割这些字符串就可以组装SQL语句导入到数据库中啦！

Answer 2

那请问怎么判断txt文件内有多少条数据

Answer 3

如上例：lstTemp.Count就是字符串列表中字符串的总数量！