I've been tasked with the following challenge: I have a text file with data in it that looks like the lines below. These lines represent three records that are extracted from a program and i have a few thousand of these to import into an access table (alternatively into an excel spreadsheet if it would be easier).


[POI]
Type=0x4400
Label=BP FUEL (SWAKOPMUND)
Data0=(-22.67827,14.52845)
[END]

[POI]
Type=0x2700
Label=JCT S=MOON LANDSCAPE
Data0=(-22.67005,14.55944)
[END]

[POI]
Type=0x2700
Label=HANDCRAFTED LEATHER
Data0=(-22.67913,14.52888)
[END]

The result should look something similar to this:

Field1 Type Label Latitude Longitude
POI 0x4400 BP FUEL (SWAKOPMUND) -22.67827 14.52845
POI 0x2700 JCT S=MOON LANDSCAPE -22.67005 14.55944
POI 0x2700 HANDCRAFTED LEATHER -22.67913 14.52888


This ofcourse should be in an Access 2003 table or an Excel spreadsheet.
Is this possible or what would be the easiest way to go about doing this? Any help would be greatly appreciated.
Thank you