I work for a company where I do quality assurance. We get a spreadsheet every week of the curent employees where I work. What I need to do is import this spreadsheet every week and update my tables.
Access will not allow me to create good relationships between other tables and the linked table. Also, if I import the table it works fine; however, the second time I import into the same table it gives me a non-descript error message.
Basically, I don't know anything about how to manage the linked data. I also need to make sure that if data is deleted from the spreasheet that it is _not_ deleted from our database. Employees may leave our company but we still need to retain their records in our database. My _main_ concern is: how do I get this linked data to tables that I can actually work with and create relationships with. I'm just a noob with Access so I'm probably missing some crucial but simple piece of information. I'm bascally looking for information on how people generally handle linked spreadsheets.
~James