On newer version of Access, updating a linked excel table is not allowed. You can read the data, but not write to it. I normally open an instance of excel and loop through the record set, adding records to the spreadsheet using the Excel object model. (Range,Cells, etc). VBA was a wonderful little tool, until it was exploited by hackers. MS applications now ask you if you want to allow Macros, which if you answer NO, defeats the entire purpose of VBA....For example, just TRY using an MS Access database to do an auto mailer in Outlook..... /rant
--- On Fri, 1/9/09, John Gonnello <[email protected]> wrote: From: John Gonnello <[email protected]> Subject: Re: [ms_access] Is there a simple way to do this? To: [email protected] Date: Friday, January 9, 2009, 8:04 PM 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 <phssthp...@yahoo. com> To: ms_acc...@yahoogrou ps.com 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] [Non-text portions of this message have been removed]
