Coding a form to update a table

  • Thread starter Thread starter Don
  • Start date Start date
D

Don

I have a table in my database that needs to have pricing updated, on a weekly
basis. I get an update in an excel sheet that is emailed to me. Is there a
way that I can program a button on a menu form, in my database, to follow a
path satement and find this excel spreadsheet and then over-write the table
that needs to be updated. I'm using access 2007.

Can someone give me the vba commands to use to write this action, if it is
possible. Thanks.
 
Back
Top