sql - Update Access Tabels using Excel tabels -
i got following problem:
i imported excel files access db using normal "functions", don't allow me update created access tables.
i can add new
datasets
using way , not update existing ones.
after research seems only possible via vba or sql.
but how work? there script can use make such update via button or such?
thanks help. matthias
you can set linked spread sheet access table allow edit data in both places iirc
Comments
Post a Comment