I have a relational database that was created by a former employee. The database has old data and I need to update it with current information. I have the most recent data in an Excel spreadsheet.
How can I get the new data into the database and maintain the relationships and populate the various tables, etc. from the Excel Spreadsheet which contains the new data?
I would greatly appreciate any and all suggestions and help on this.
Thanks in advance
Free Guide: Managing storage for virtual environments
Complete a brief survey to get a complimentary 70-page whitepaper featuring the best methods and solutions for your virtual environment, as well as hypervisor-specific management advice from TechTarget experts. Don’t miss out on this exclusive content!