I ended up doing the following: 1. I uploaded the Excel spreadsheet to a temporary table. I will replace it every time. 2. I did a quick update query with a one to one for each field that matches on the Requisition number. If it finds a match, it updates all the fields in the master table of requisitions. 3. I then upload the excel spreadsheet to the master table. The adds the new records from the spreadsheet.
Thanks for all the help. I will be back. Jan --- On Sun, 1/18/09, anglospice <[email protected]> wrote: From: anglospice <[email protected]> Subject: [ms_access] Re: Is there a simple way to do this? To: [email protected] Date: Sunday, January 18, 2009, 4:23 AM 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 ms_acc...@yahoogrou ps.com, "Jan" <phssthpok3@ ...> 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 > [Non-text portions of this message have been removed]
