export access to excel and then after updating refresh the tables in access

[Julia]

Is it possible that I export access table datas to excel,
updat these data in excel and then by closing excel update
the datas in access? Thanks for helping me

 

[John Nurick]

Hi Julia,

It's possible, but it's usually simpler to work entirely in Access. One
particular problem is that it's very difficult to ensure that the data
entered or edited in Excel conforms to the field types and relational
constraints in the Access database; unless it does, the update process
will fail.