How can I import multiple .xlsx and .xls files into multiple tables in Access?
I haven't done MSSQL in a while but if I remember you can do a ssis package.  I think its part of sql management studio. Where you can read in files and do inserts.