HI! MajP, how are you sir, i have been working on a project, have a difficulty in converting txt file data into access because of the spaces in the text file where i am not able to import into access. you had helped me on a similar text trim, but this is of different nature. Would you mind helping me in my project. below is the link of my text file which you had helped me earlier.
https://www.access-programmers.co.uk...=300423&page=3
i will wait for your reply. Thanks MajP