I can query and view the table through excel, but I was wondering if there is a way to directly update or insert by modifying the data in excel.
Like a Microsoft Access Linked spreadsheet, maybe?
You can use VBA, ADODB and the data driver to write your own application for this. But in Excel there is nothing for writing and ODBC data source. QueryTables in Excel are read-only.