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

  • Thread starter Thread starter Julia
  • Start date Start date
J

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
 
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.
 
Back
Top