I want to create import filter form text files like one in Excel.. My text file in fixed length and columns in file are separated with spaces.

When i determine witch field is witch I write data into access database. Text file looks like this - but not always:

08/14/00 10:05AM 28 09 041427330 00:00'48
08/14/00 10:09AM 11 09 --802-5384-- 00:00'23
08/14/00 10:15AM 392 09 00:00'50
08/14/00 10:19AM 392 10 00:00'33
08/14/00 10:21AM 28 09 216927 00:02'41
08/14/00 10:26AM 28 09 216927 00:01'12

It also may look like this:

08/14/00 10:05AM 28 09 041427330 00:00'48
08/14/00 10:09AM 11 09 --802-5384-- 00:00'23
08/14/00 10:15AM 392 09 00:00'50
08/14/00 10:19AM 392 10 00:00'33
08/14/00 10:21AM 28 09 216927 00:02'41
08/14/00 10:26AM 28 09 216927 00:01'12

Did anyone done this?!

Thnx