这样的文本文件如何读取到指定形式的数据库？

各位大侠小弟有如下所示格式的文本文件，想通过vb读取到Access数据库，生成两个表如后面表1和表2所示：望各位大侠能帮帮忙！多谢多谢！
1                                                                                                                                  
 -------------------------------------------------------------------------------------------------------------------------------
 Ssfsdfsfsfssfsfd                                         
 -------------------------------------------------------------------------------------------------------------------------------
 DATE         YEARS        YOPF         YOPF         YOPF         YOPF         YOPF         YOPF         YOPF         YOPF         
              YEARS        SSS/YYY      SSS/YYY      SSS/YYY      SSS/YYY      SSS/YYY      SSS/YYY      SSS/YYY      SSS/YYY      
                           PPRODD1      PPRODD1      PPRODD1      PPRODD1      PPRODD1      PPRODD1      PPRODD1      PPRODD1      
                           68  17 175   68  17 176   68  17 179   68  17 180   68  17 181   70  14 251   70  14 252   70  14 253   
 -------------------------------------------------------------------------------------------------------------------------------
  1-OCT-2007  3.950719     -0.00086     -0.05162     -0.00487     -2.58390     -1.08444     0.031465     0.001091     0.759640     
  4-OCT-2007  3.958932     -0.00102     -0.06153     -0.00420     -2.24231     -0.94769     0.021060     0.000726     0.501129     
 13-OCT-2007  3.983573     -0.00101     -0.06077     -0.00365     -1.95683     -0.83951     0.012496     0.000424     0.288127     
1                                                                                                                                  
 -------------------------------------------------------------------------------------------------------------------------------
 Ssasasasasasasa                    
 -------------------------------------------------------------------------------------------------------------------------------
 DATE         YOPF         YOPF         YOPF         YOPF         YOPF         YOPF         YOPF         YOPF         YOPF         
              SSS/YYY      SSS/YYY      SSS/YYY      SSS/YYY      SSS/YYY      SSS/YYY      SSS/YYY      SSS/YYY      SSS/YYY      
              PPRODD1      PPRODD1      PPRODD1      PPRODD1      PPRODD1      PPRODD1      PPRODD2      PPRODD2      PPRODD2      
              70  14 266   70  14 267   70  14 268   71  13 272   71  13 273   71  13 285   76  23 108   77  23 115   77  23 116   
 -------------------------------------------------------------------------------------------------------------------------------
  1-OCT-2007  0.000394     2.494977     0.112812     0.051662     0.003156     0.270484            0            0            0     
  4-OCT-2007  0.000379     2.393710     0.104810     0.035811     0.002175     0.196945            0            0            0     
 13-OCT-2007  0.000359     2.295813     0.092108     0.024308     0.001463     0.146676            0            0            0     
1                                                                                                                                  
 -------------------------------------------------------------------------------------------------------------------------------
Ssfddsfsdaaaadds                                                                   
 -------------------------------------------------------------------------------------------------------------------------------
 DATE         YOPF         YOPF         YOPF         YOPF         YWPF         YWPF         YWPF         YWPF         YWPF         
              SSS/YYY      SSS/YYY      SSS/YYY      SSS/YYY      SSS/YYY      SSS/YYY      SSS/YYY      SSS/YYY      SSS/YYY      
              PPROD13      PPROD13      PPROD13      PPROD13      PPRODD1      PPRODD1      PPRODD1      PPRODD1      PPRODD1      
              82  16 180   82  16 181   82  16 188   82  16 189   68  17 175   68  17 176   68  17 179   68  17 180   68  17 181   
 -------------------------------------------------------------------------------------------------------------------------------
  1-OCT-2007  -0.76623     -0.01900     0.300549     0.055287     -0.02326     -1.40226     -0.13236     -70.1943     -29.4599     
  4-OCT-2007  -0.41915     -0.00978     0.354212     0.064709     -0.02693     -1.62247     -0.11078     -59.1302     -24.9908     
 13-OCT-2007  0.860051     0.011455     0.423857     0.074575     -0.02585     -1.56037     -0.09382     -50.2437     -21.5554     表1
  NAME           DATE           YOPF           YWPF
68  17 175 2007-10-1 -0.00086 -0.02326
68  17 175 2007-10-4 -0.00102 -0.02693
68  17 175 2007-10-13 -0.00101 -0.02585
68  17 176 2007-10-1 -0.05162 -1.40226
68  17 176 2007-10-4 -0.06153 -1.62247
68  17 176 2007-10-13 -0.06077 -1.56037
68  17 179 2007-10-1 -0.00487 -0.13236
68  17 179 2007-10-4 -0.00420 -0.11078
68  17 179 2007-10-13 -0.00365 -0.09382GROUP      NAME
PPRODD1 68  17 175
PPRODD1 68  17 176
PPRODD1 68  17 179