How do i update Access Table using data from Excel spreadsheet

[kkatwork]

Is it possible to update an existing Access table with data from an excel
spreadsheet? Records to be updated in table are uniquely identified by a ID
which is referenced by the data in the excel spreadsheet. Note that data in
Excel spreadsheet may be an update to records already in the Access table or
may be new records.

tia

 

[Jeff Boyce]

Yes, you can make an Access table have a copy of data in an Excel
spreadsheeet.

Why, though? If the data is already in Excel, and if you don't need to
update the data from Access, you could "link" to it instead of importing it.

And if you do decide to do both update AND load new records, you could still
start with a linked Excel spreadsheet and use queries (Update; Append) to do
that.

Regards

Jeff Boyce
Microsoft Office/Access MVP

 

[kkatwork]

I don't think linking is a good option for me. I receive updates twice a
month in Excel -- I need to use that data to update my database.

 

[Jeff Boyce]

"Update" may mean different things to different folks ...

If you are saying that you receive update information in the form of Excel
spreadsheets, you may still be able to use a link to those spreadsheets to
"see" the data, then use queries to update your more permanent (and
well-normalized) Access tables.

For this approach to work, you'd need to have the same name and location for
the Excel spreadsheets each month...

Regards

Jeff Boyce
Microsoft Office/Access MVP