locked
Accessing JDBC resources from MS Access and/or MS Excel RRS feed

  • Question

  • Is it possible to access JDBC resources from MS Access and/or MS Excel? I have an application which provides a JDBC interface but NOT an ODBC interface.
    Tuesday, September 9, 2008 8:12 PM

Answers

  • Jim,

    My understanding is that there is a JDBC - ODBC bridge that ships as part of the Sun Java 2 SDK. Beyond that I am unable to recommend any specific solutions but you might check on SourceForge or Code Project.

     

    I hope this helps.

     

    Steve Smegner

    Application Development Consulting Group

    • Proposed as answer by Steve Smegner Thursday, September 11, 2008 3:35 AM
    • Marked as answer by David DoBell Thursday, September 25, 2008 4:45 AM
    Thursday, September 11, 2008 3:35 AM

All replies

  • You will need ODBC or one of the flat file formats for both Excel and Access. Excel can also utilize an OleDB interface. Your best bet is probably to use a JDBC to ODBC bridge.

    Steve Smegner
    Application Development Consulting Group
    • Proposed as answer by Steve Smegner Wednesday, September 10, 2008 8:25 AM
    Wednesday, September 10, 2008 8:25 AM
  • Thanks, I had sort of assumed I would need a ODBC to JDBC bridge. Searching the web I have found several commercial products. Are you aware of any open source, low cost or "free" bridges?

    Jim

    Jim Elliott
    Wednesday, September 10, 2008 1:46 PM
  • Jim,

    My understanding is that there is a JDBC - ODBC bridge that ships as part of the Sun Java 2 SDK. Beyond that I am unable to recommend any specific solutions but you might check on SourceForge or Code Project.

     

    I hope this helps.

     

    Steve Smegner

    Application Development Consulting Group

    • Proposed as answer by Steve Smegner Thursday, September 11, 2008 3:35 AM
    • Marked as answer by David DoBell Thursday, September 25, 2008 4:45 AM
    Thursday, September 11, 2008 3:35 AM