Write a Simple update query using the key as a match you can import the excel file using a simple macro & use the same macro to do the update
John ________________________________ From: Jan Hertzsch <[email protected]> To: [email protected] Sent: Friday, January 9, 2009 12:10:30 PM Subject: RE: [ms_access] Is there a simple way to do this? Not a bad idea. Thank you --- On Thu, 1/8/09, GraphixGuy <graphix.guy71@ gmail.com> wrote: From: GraphixGuy <graphix.guy71@ gmail.com> Subject: RE: [ms_access] Is there a simple way to do this? To: ms_acc...@yahoogrou ps.com Date: Thursday, January 8, 2009, 8:32 PM Jan, I would link your excel file to your database then it looks like a table in your db when the excel file gets updated it will update in the db as well then if you want to do any other functions with the data base grab it from the linked file using a query and paste the new info to a new table there is a lot of info on linking tables and excel files out there and lots of folks on here who could tell you exactly how to do it I am in the process of doing the exact same thing and am getting mine to the point where I will soon be posting looking for some help as well I hope this has been some help to you Bill -----Original Message----- From: ms_acc...@yahoogrou ps.com [mailto:ms_access@ yahoogrou ps.com] On Behalf Of Jan Sent: January-07-09 9:21 PM To: ms_acc...@yahoogrou ps.com Subject: [ms_access] Is there a simple way to do this? 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 ------------ --------- --------- ------ Yahoo! Groups Links [Non-text portions of this message have been removed] [Non-text portions of this message have been removed]
