The path to automatically generate a loadspec from an Excel file and to automatically generate a table definition to support the load is as follows:
Excel, then load-spec, table generation, then drop/create those tables, then load excel to table, and then stage/load from table to rowsource.
You can re-use the loadspec for uploadable reports.