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.
 
You must log in or register to reply here.

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Similar Threads

VBA Excel - Select a value from one cell in Excel to update a SQL table 1
Form Code to update the table 15
One form, two tables UPDATE help? 4
Access Updating an access table froma form that includes a listobox 0
How to export table from outlook into ms access table? 0
Change paths to linked external data 3
Update Two Tables Using One Form Contents 0
Data entry for a table from a form 1

Back
Top