Import Data into MS Access

This will require some VBA code to sequentially process the records.
The H and D types indicate to me that you have a master (order?) record and a child (OrderDetails) record that will belong to the master.

You'll need code like:

Expand|Select|Wrap|Line Numbers

1. ' define recordsets for master and detail table
2. dim rsMaster as DAO.recordset 'This requires Tools/References to hold a Microsoft DAO version #.## reference
3. dim rsDetail as DAO.recordset
4.  
5. dim strLine as string
6. dim strKey as string
7.  
8. set rsMaster = currentdb.openrecordset("tblMaster")
9. set rsDetail = currentdb.openrecordset("tblDetail")
10.  
11. open "C:\input\myfile.txt" for input as #1
12. while not eof(1)
13.   input #1, strLine
14.   if len(strLine) > 1 then
15.   select case left(strLine,1)   
16.    case "H"
17.      strKey = mid(strLine,2,10)
18.      rsMaster.addnew
19.      rsMaster!Keyfield = mid(strLine,2,10)
20.      rsMaster!Field1 = mid(strLine,12,10)
21.      '... etc
22.      rsMaster.Update
23.    case "D"
24.      rsDetail.addnew
25.      rsDetail!Keyfield = strKey
26.      rsDetail!Field1 = mid(strLine,12,8)
27.      rsDetail!Field2 = mid(strLine,20,5)
28.      '... etc
29.       rsDetail.Update
30.    end select
31.   endif
32. wend
33.  
34.  

It's "aircode", but I hope it gives the idea how to process the data.
Each row not starting with H or D will be ignored and the H will define the key for the D.

Nic;o)