How to Format the text file

[prasadgov]

Hi,

I have a text file (attached), which contains data in the below format, which I need to import into Access table.




I have a parsing sql as below

(select top 1 value from #temp where field_id='20c') as 'Message_Reference',



(select top 1 value from #temp where field_id='98c') as 'Prep_DateTime',



(select top 1 value from #temp where field_id='36B') as 'Quantity',



(select top 1 value from #temp where field_id='19A') as 'Settled Amount'



,convert(datetime,@inserteddate,101),



(select top 1 value from #temp where field_id='98A') as [Settlement_Date_Time]



,     (select top 1 value from #temp where field_id='20C') as [RELA]



,     (select top 1 value from #temp where field_id='35B') as [security]

How do i read this into a table in Access?

TIA