Have a huge DB that I did too much work to before making sure I was creating it properly. Was back tracking and trying to normalize and set up relationships and referential integrity but ran into the following issue:
The database uses tables which are periodically updated through imports from Excel. My problem is if I create relationships on any of the data that needs to be reimported, I am unable to import data without needing to break the relationship.
What is the point of creating these relationship considering this limitation or is there another method I should be using to maintain referential integrity?
I also tried linking the source data through an ODBC link and it is SO SLOW because the source data goes back over 10 years and would max the DB size out with one table... hence why I use excel to import current data versus using the whole historical data set.
The database uses tables which are periodically updated through imports from Excel. My problem is if I create relationships on any of the data that needs to be reimported, I am unable to import data without needing to break the relationship.
What is the point of creating these relationship considering this limitation or is there another method I should be using to maintain referential integrity?
I also tried linking the source data through an ODBC link and it is SO SLOW because the source data goes back over 10 years and would max the DB size out with one table... hence why I use excel to import current data versus using the whole historical data set.