Hi,
I have text file contain data in line straight like this
07504998547 01:10:05 01:10:45 AA
1)I want this 07504998547 copy into filed in access table phone_no in access table
2)I want 01:10:05 copy start_date in access table
3)I want 01:10:45 copy end_date in access table
4)copy AA into name in access table
see attached two file access phone.mdb info.txt
please make code in that file send me back
thx