scan .exf file for desired data

[hniessen]

Dear experts,

I'm trying to import data from a file Epl_asc.exf. This file is generated by another programm and is ascii compatible. Within this file I am looking for lines that start with code '117' (at the end of this message I added a fragment if the file). As you can see the data is not delimited by a comma or semi-colon everwhere. So I was thinking to create some sort of turing machine that scans the file and imports the desired data into a table. But here lies the problem for me. How can I create some sort of turing machine within Access with help of VBA.

I want to thank everbody in advance who is willing to rack his\her brain over this problem.

Hans Niessen

fragment if the file Epl_asc.exf:

850 1120,7360,0,255,-84
105 1,3,0,0,NHOOFDZEKERING: 25A
998 DHAUPTSICHERUNG: 25A
998 EFUSE IN MAIN: 25A
998 FFUSIBLE DE SECTEUR: 25A
998 SFUSIBLE PRINCIPAL: 25A
998 OHOVEDSIKRING: 25A
998 K
998 PFUS¡VEL NA REDE: 25A
998

850 1440,1120,0,255,-281
851
852 166,7,0,4,0

850 1440,3520,0,255,-198
117 1,1,1,0,1L1

850 1440,5760,0,255,-128
116 10,7,1,4,0
116 1,960,160,960,160
116 1,960,160,960,160
116 10,2,3,4,0
116 1,640,160,960,160


"Funny how such little knowledge can get me into so much trouble"