I have an Excel spreadsheet that is relatively simple. It has the following structure:
A user may have multiple subordinates, and multiple users will be on the same server, so multiple values for user, subordinate and server must be allowed.
- User Name
- Subordinate
- Home Server
- Department
I would really like to import this into three linked tables, a user table that links to both a subordinate table and a server table. If possible, I would also like to link the subordinate table to the server table to add that data in later.
I can get a simple import, and then using the analyzer tool, break the relationships out. The issue is when the analyzer starts checking the data, it wants me to replace approximately 13,000 of the 14,000 users with alternate data, and to click on each to say leave as is very impracticle.
Is there a better way to be doing this?
Cheers