I've been given a bit of a nightmare.
Marketing wants me to import an excel spreadsheet into the database that has over 2k columns. I've redesigned this catastrophe of a table into 10 different tables with 80 total columns in sql.
However, it is my understanding that in order to import all of these rows and columns into their respective tables, I need to import the data into a staging table, but sql server requires (reasonably) that each table has under 1k columns.
I've thought about creating multiple spreadsheets, cutting the spreadsheets into segments, and having the staging tales linked based on the Id in the excel spreadsheet.
Is there a better way to do this?
Aucun commentaire:
Enregistrer un commentaire