Good stuff and totally understood.  The only question I have now is how do decide which group any given file is in?  I don't know of a reason why that...

Right now, after you've uploaded (imported) a file to a named table, what do you want done with the file?

Once the files are uploaded, there are there are...

Sorry, how do I go about Jeff's method of using BULK INSERT. Is it an SQL query ?

I was playing around with the ForEach loop container to try and understand...

Thanks Jeff

I haven't heard of ACE driver. Is it a tool ? if so, can you share a link please. I am not sure how to use bulk insert for...

EDIT

As this might be a long read, here is the TL;DR version

I want to upload multiple csv files into an SQL database such that a new table is created for...