CODEWITHSUNDEEP
excelodbc
sayhaha
sayhaha

Reputation: 789

Update ODBC DB through Excel

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?

Upvotes: 8

Views: 5707

Answers (1)

Dick Kusleika
Dick Kusleika

Reputation: 33145

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.

Upvotes: 8

Related Questions