Daily data updates from an Excel Spreadsheet

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
 
J

Joe Fallon

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.
 

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

Linking data in MS Word into Excel 5
Refreshing Data Daily From a Linked Excel Spreadsheet 2
How do i update Access Table using data from Excel spreadsheet 3
Import Updated Data from and Excel to Access 2
Excel Import / Referential Integrity Question 8
Data not showing from Linked Excel 3
Importing from a spreadsheet, update or append query? 5
Import data and update changed information 1

Top