EDI into Access table

[ramiahragu]

i have below text file.. i want to load this on a access table

'EQD+CN+BFSU4533400+4500:102:5++2+4
'RFF+BN:244390
'DTM+7:200708201032:203
'LOC+165+AEJEA:139:6+11:TER:ZZZ
'MEA+WT+G+KGM:4200
'EQD+CN+BAXU2625601+2300:102:5++2+4
'RFF+BN:244388'DTM+7:200708201039:203
'LOC+165+AEJEA:139:6+11:TER:ZZZ
'MEA+WT+G+KGM:2300
'SEL+N/A+CA

can someone tell me what is the best way!!

 

[Pat Hartman]

If the file is delimited or fixed, you can use the TransferText Method/Action. You'll need to import the data once manually. You can save the import spec so that you can automate the process for subsequent imports.