Hi all!
Is there a way in standard Excel to bind (read-write) cells to data stored in a database? If not, can the functionality be accomplished with an add-in, which one(s)? Or can this be accomplished only with VBA?
So far I have successfully managed to connect an Excel workbook to a database (MySQL) via PivotTable & ODBC driver. Then, by using the GETPIVOTDATA function, I have been able to bind (read only) the desired data from the PivotTable to, for example, desired cells on another sheet. What I have not figured out yet is how to write back data from that Excel to a database (via PivotTable).
Thanks in advance!
+Markku
Is there a way in standard Excel to bind (read-write) cells to data stored in a database? If not, can the functionality be accomplished with an add-in, which one(s)? Or can this be accomplished only with VBA?
So far I have successfully managed to connect an Excel workbook to a database (MySQL) via PivotTable & ODBC driver. Then, by using the GETPIVOTDATA function, I have been able to bind (read only) the desired data from the PivotTable to, for example, desired cells on another sheet. What I have not figured out yet is how to write back data from that Excel to a database (via PivotTable).
Thanks in advance!
+Markku
