Are currently using Excel as a database and it gets uglier by the day. I can put this into an MS Access database but I am stumped on how to handle something (rookie, can you tell?) and thought I would ask.
I have created a table with data. We get a weekly update to the data in the form of an Excel spreadsheet. It has new records and changed records. We have a unique reference field that I can use as an external primary key. In a perfect world, I would change the fields in the records that are already in my database and load the new records. I can't believe I am the first person to run into this but I don't see a solution in my MS Access reference book. Any thoughts? Thanks Jan
