You're going to struggle to work with the file in the format it's in. SQL needs your data to be organised into discrete entities with rows and columns. Your file is organised with data on alternate rows and has metadata embedded within the data structure itself.
If it was me, I'd write a VB script to process the data first. But then, I'm a bit old fashioned :-)