Good day - extremely new to using SQL so I apologize in advance for any silliness in my query. Since I don't know much about SQL, I can't really say if this is even possible, but from what I've read, I believe it should be.
We have developed an automated process whereby spreadsheets are distributed to anywhere from 3-10 people every day. Those people do some stuff in their spreadsheets, and save them to a repository. I currently have a VBA macro that collects the data from each of those sheets by looping through the repository until all the files are accounted for. It then moves them to another directory where they get dumped into a zip file (manually). I realize that it would make more sense to use a web front end or even a distributed MS Access form, but the requirements I have to work with are for Excel spreadsheets.
It seems to me that SQL is a LOT faster and more reliable. I'd like to set up a similar process, but not really sure how to get it to access each file (the number of files can vary from day to day).
The columns (there are only 12) are always in the same order, which replicates the db table. Each sheet contains about 300 lines, but that will be increasing to 1000 over the next two months.
Is this something that can even be done without having to manually import one file at a time, using the file name?
Thank you for any help!