Solved

Connect to a database from Excel using JDBC instead of ODBC

Posted on 2016-11-22
3
26 Views
Last Modified: 2016-11-28
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?).
0
Comment
Question by:SteveSweeney
3 Comments
 
LVL 3

Accepted Solution

by:
Mike in IT earned 250 total points
ID: 41897998
Take a look at this, it might help point you in the right direction.
0
 
LVL 6

Assisted Solution

by:nathaniel
nathaniel earned 250 total points
ID: 41901315
also, you may want to look at this:

Video for work on VBA with JDBC
https://www.youtube.com/watch?v=vSViCJ2feRE
0
 

Author Closing Comment

by:SteveSweeney
ID: 41905070
Thanks for the input!
0

Featured Post

How to run any project with ease

Manage projects of all sizes how you want. Great for personal to-do lists, project milestones, team priorities and launch plans.
- Combine task lists, docs, spreadsheets, and chat in one
- View and edit from mobile/offline
- Cut down on emails

Join & Write a Comment

Suggested Solutions

If you need to start windows update installation remotely or as a scheduled task you will find this very helpful.
This code takes an Excel list of URL’s and adds a header titled “URL List”. It then searches through all URL’s in column “A”, looking for duplicates. When a duplicate is found, it is moved to the top of the list. The duplicate URL’s are then highlig…
Viewers will learn the basics of slicers and timelines for both PivotTables and standard Excel tables in Excel 2013.
This Micro Tutorial will demonstrate in Google Sheets how to use the HYPERLINK function to create live links inside your spreadsheet.

708 members asked questions and received personalized solutions in the past 7 days.

Join the community of 500,000 technology professionals and ask your questions.

Join & Ask a Question

Need Help in Real-Time?

Connect with top rated Experts

15 Experts available now in Live!

Get 1:1 Help Now