So I read through all the previous post I could find but none of the sample code worked.
I don't need anything fancy.
Just want to import all the files in a directory to 1 table, not necessary named .csv at the moment. I can make sure all the files in the directory are relevant, so no checking is needed.
I have 3,500 files :)
They are delimited with a comma for the fields I'm interested in.
Later I want to filter out some of the fields but for now I just want to start with some basic working VB code.