Update ODBC DB through Excel

Question

I am able to query and view table through excel, but I was wondering if there is a way to directly update or insert by modifying data in the excel.

Similar to Microsoft Access Linked table, maybe?

Answer 1

You can use VBA, ADODB, and the data driver to write a custom application to do this. But there is nothing built in to Excel for writing back to an ODBC data source. QueryTables in Excel are read-only.