• Status: Solved
  • Priority: Medium
  • Security: Public
  • Views: 2024
  • Last Modified:

Connect to a database from Excel using JDBC instead of ODBC

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?).
1
SteveSweeney
Asked:
SteveSweeney
2 Solutions
 
Mike in ITIT System AdministratorCommented:
Take a look at this, it might help point you in the right direction.
0
 
nathanielIT ConsultantCommented:
also, you may want to look at this:

Video for work on VBA with JDBC
https://www.youtube.com/watch?v=vSViCJ2feRE
0
 
SteveSweeneyAuthor Commented:
Thanks for the input!
0

Featured Post

The new generation of project management tools

With monday.com’s project management tool, you can see what everyone on your team is working in a single glance. Its intuitive dashboards are customizable, so you can create systems that work for you.

Tackle projects and never again get stuck behind a technical roadblock.
Join Now