Hi All,
This is my first time - I just would like to get some help in linking a txt file in MS access the file looks like this :-

XX061020082120
XX061020083140

And so on
What i need is to import them in a different 3 different fields,
XX first field Text format
061020 second field date format in (D/M/Y) currently its in (Y/M/D)
082120 third field format is in Time format ...