Is it possible to connect to a database from Excel using JDBC instead of ODBC? I'm connecting to Teradata from Excel. I can use the ODBC connection but Microsoft updates are causing issues for our users. Our jdbc drivers seem to work flawlessly via other programs. I was wondering if there was a way to connect to a database via a jdbc driver from Excel (VBA?).
Freeze panes is an option within all variants of Excel to enable parts of a sheet to remain stationary when the cursor is in another part of the sheet. This is a very useful feature which is overlooked or under used.