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?
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.