Personally, I would have not created a SQL script at all. I would have created a VBA module (formerly known as an Excel macro) that reads the spreadsheet columns and creates a text file/SQL script as output, containing Create Table statements, which will create all of the tables. Then you just have to open the generated SQL script and run it. The Excel macro could create one script per table, or one per several tables.

That seems simpler to me. But then, I'm good with both SQL and VBA.