Trouble importing unusual text file

[richo2]

Hi everyone

Here is an example of a text file that I am trying to import into an Access table:

2.100 157.3 -999.25 4000.0 -999.25
2.200 139.1 -999.25 4000.0 17.0
2.300 122.7 -999.25 4000.0 16.2
2.400 131.8 2.27 4000.0 16.1
2.500 140.9 2.44 4000.0 16.1
2.600 124.5 2.68 4000.0 16.7

You can see that the spacing between the numbers is always the same. A delimited import separated by tabs will NOT recognise these spaces and insert the numbers into their respective fields!

The data can import into Excel properly - but only if you tick the box "Treat consecutive delimeters as one" - and Access does not seem to have this functionality.

Can anyone recommend a soloution to this headache??!!!

Andrew

 

[richo2]

more info...

I just noticed the post did not display the example properly. Depending on the size of the number, the spaces between them vary. Sometimes it's 5, othertimes it is 4.

Anyway, the actual problem file is now attached. You will see the five columns of data further down.