VBA script to import regular txt files into MS ACcess

We receive refular text files via FTP.
They are multi lined text files (example attached)
I need to setup some VBA that scns the directory for any new files .
Import them into access.

Most order files have 1 item, but can have several.
We are not interested in the detail rows, only to know how many detail rows there are.

example:
"HEADER","INVOICE","00701439","28/08/2024","","S398","GBP","#7538361-10755","","****"
"DETAIL","1","8436563184826","1","Stereo Dri","CECIL TAYL","#7538361-10755","1","20","8.99","1.80","8.99","","","8.99","1.80"
"SAC","2","","1","SHIPPING","","C","1","20","2.22","0.44","2.22","0","2.22","2.22","0.44"
"SAC","3","","1","HANDLING","","C","1","20","0.95","0.19","0.95","0","0.95","0.95","0.19"
"TAXSUMMARY","1","3","20","12.16","2.43"
"TOTAL","8.99","0.00","3.17","2.43","14.59"
"TRAILER","00701439","1","3"