Daily data updates from an Excel Spreadsheet

  • Thread starter Thread starter DJohnson
  • Start date Start date
D

DJohnson

I am trying to figure out how to update one table in my
database from an Excel spreadsheet. The spreadsheeet is
updated daily, with some records being added, some being
edited, and some being deleted. At the end of each day,
the table in Access must match the records in the
spreadsheet. Is there a query I can use (even in SQL,
which I might be able to stumble through), that can make
the Access table compare it's records to the Excel file,
and add those records that are new in the Excel file, or
delete those records that no longer match to Excel?
What's the best way to go about this?

Thank you so much!

Denielle Johnson
 
Personally,
I would write the app in Access and eliminate the use of the Excel
spreadsheet altogether.
All those headaches are now gone.
Plus lots of side benefits.
Access is multi-user.
 
Back
Top