If you link to the Excel spreadsheet it will become a table in Access. You could use this and your new table in Access and then write a query which updates one from another. You would have to link by some kind of ID, but it should work.
For FREE Access ebook and videos click here http://access-databases.com/ebook --- In [email protected], "Jan" <phssthp...@...> wrote: > > 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 >
