import text into tables

[ymeyaw]

Dear all,
i had a very messy txt files and i would like that to populate into table. I know very mimimum bout transfertext. So, is there any one can guide me or any example coding that i can refer to? Thanks in advance as i had been scratching my head for the past few weeks to manipulate my company employees profile (more than 500 records) in a very manual way.


Here's one of my txt file, say 1.txt

==========================
david profile
==========================
age 28
sex male
address 28 washinton road 20056
==========================
xxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxx
xxxxxxxxxxxxxxxxxxxxx@#$@#%#$^$
xxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxx
==========================
cindy profile
==========================
age 23
sex female
address 7 26 washinton road 20056
==========================
xxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxx
xxxxxxxxxxxxxxxxxxxxx&*^&*%^%^##$%%&
xxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxx
@@##$^^%

The table which i wish to have in access is:

profile age sex address
david 28 male 28 washinton road 20056
cindy 23 female 26 washinton road 20056
(continue with remaining txt files in one table)

[namliam]

Try looking up the Open statement in VBA and reading up on "Line Input" and stuff like that...

You can use that to manipulate your import the way you want to...

Greets