Is there a better way than the ones listed within to join data in an excel spreadsheet to a table in a SQL Server database?
Great question! Especially the "monster query" part ;)The answer is this guy here, enjoy: Excel Data Source as Linked Server