Load text file to Access

[ramiahragu]

i have below text file, i wanted to to load the data in access


'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
'EQD+CN+BAXU2634619+2200:102:5++2+4
'RFF+BN:244375
'DTM+7:200708201036:203
'LOC+165+AEJEA:139:6+11:TER:ZZZ
'MEA+WT+G+KGM:2000

can someone tell me what is the best way to do it?

 

[Oldsoftboss]

A bit more info may be required. Is the info to go into one field, or each line to a different field?

But yes, it is quite possible to read a text box.

Dave

 

[ramiahragu]

i will have below 5 tables
EQD, REF, LOC, MEA, SEL

Every table will have below fields
i.e. on EQD Fields: EQType, EqpNo, EQPISO, TypeCode, Ref, LoadStatus,

Data Should load as below
EQType: CN
EqpNo: BAXU2625601
EQPISO: 2300
TypeCode: 102
Ref : 5
LoadStatus: 2

like this for every line. The data is seperated with + and :

 

[Oldsoftboss]

Hope this helps

 

[Oldsoftboss]

Will have a look,

Dave

 

[Guus2005]

Look for my recursive getpart function:http://www.access-programmers.co.uk/forums/showthread.php?t=130858