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 <phssthpok3@...>
To: ms_access@yahoogroups.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_access@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_access@yahoogrou ps.com [mailto:ms_access@ yahoogrou ps.com] On Behalf
Of Jan
Sent: January-07-09 9:21 PM
To: ms_access@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]