急求!批量从txt文件中,提取对应数据导入到excel表格~~
我有24个txt文件,对应24个月。每个文件有100万条以上的数据。数据格式"01","02","03",04","05","06","07","08","09","10...
我有24个txt文件,对应24个月。每个文件有100万条以上的数据。数据格式"01","02","03",04","05","06","07","08","09","10","11","12","13","14","15","16","17","18","19","20","21"其中01-21对应相应内容。其中05对应客户编号。
问:我现在想将24个txt文件中的,其中包含50个客户编号。的所有04、05、06、14、16、17、19项分7列,列入excel表中。
请问具体用什么软件,如何操作。
"130000","经济开发区大运街3758","上岛咖啡","林冬梅","764250300562","2007-08-13","李涛"," a"," b","c","d"," e","f","07/02","g","764250300728","47851841","h"," 725.00/RMB","","0"
"130000","经济开发区大运街3758","上岛咖啡","李明","764250300561","2007-08-25","李涛"," a"," b","c","d"," e","f","07/03","g","764250300701","47851233","h"," 135.00/RMB","","0"
格式是一样的但是,长度是不一样的。其中有一些是没有内容的如本例子中的20项就是空的。 以上格式不变导出成txt格式也可以。 展开
问:我现在想将24个txt文件中的,其中包含50个客户编号。的所有04、05、06、14、16、17、19项分7列,列入excel表中。
请问具体用什么软件,如何操作。
"130000","经济开发区大运街3758","上岛咖啡","林冬梅","764250300562","2007-08-13","李涛"," a"," b","c","d"," e","f","07/02","g","764250300728","47851841","h"," 725.00/RMB","","0"
"130000","经济开发区大运街3758","上岛咖啡","李明","764250300561","2007-08-25","李涛"," a"," b","c","d"," e","f","07/03","g","764250300701","47851233","h"," 135.00/RMB","","0"
格式是一样的但是,长度是不一样的。其中有一些是没有内容的如本例子中的20项就是空的。 以上格式不变导出成txt格式也可以。 展开
展开全部
能把txt图像贴上来看看吗,是不是所有的格式都一样,包括字段长度等
就是说你所得内容是""中的,然后以逗号分开,那么是不是每行数据的个数都是一样,如果是的话,就有办法,用vba的open for input语法,去读每个txt文件,然后记录符合你条件的数据,但是数据量有点大,所以会有点慢。因为你的数据量比较大,所以导入excel是不可能的,excel只能支持6w多条数据,或者你用access导入数据也可以。
就是说你所得内容是""中的,然后以逗号分开,那么是不是每行数据的个数都是一样,如果是的话,就有办法,用vba的open for input语法,去读每个txt文件,然后记录符合你条件的数据,但是数据量有点大,所以会有点慢。因为你的数据量比较大,所以导入excel是不可能的,excel只能支持6w多条数据,或者你用access导入数据也可以。
更多追问追答
追问
是的,全是由21个项目组成
追答
用vba吧,你把文件发给我,exce格式也发给我,然后你需要的客户名称发给我,我帮你做吧
tiger9502@sina.com
本回答被提问者和网友采纳
已赞过
已踩过<
评论
收起
你对这个回答的评价是?
展开全部
数据量太大我建意议用SQL 来做
已赞过
已踩过<
评论
收起
你对这个回答的评价是?
推荐律师服务:
若未解决您的问题,请您详细描述您的问题,通过百度律临进行免费专业咨询