Take the tour ×  I've started a new role which deals with large
amount of related data. Our source of all this data is various
Excel dumps pulled from databases we do not have access to. The
previous person filling this role used a dozen or so Excel files
to gather these data files, manipulate them, and create reports.
I have started moving the dumps to an Access database. I have
noticed a lot of the Excel data is related and should probably
be normalized. What I have currently been doing is creating a
table for every data dump, and importing them to Access, and
using a number of queries to replicate the dozens of data
manipulations and reporting.  Are there still benefits to
normalizing data where my only source are Excel dumps out of a
warehouse?  How would I normalize data, when I do not have the
ability to change the format of how the dumps are sent to me?
Additionally, my plan (budget-depending) is to move from Access
to a MS SQL Database.  share|improve this question Normally, you
do NOT want to norma