![]() ![]() You can use the Easysoft JDBC-Access Driver to connect Java applications, servlet/JavaServer Pages (JSP) engines, integrated development environments (IDE) and application servers with Access and Excel. Because this ODBC driver library also supports Excel, the Easysoft JDBC-Access Driver also provides JDBC access to Excel. The Easysoft JDBC-Access Driver is a JDBC driver for Access that uses the Java Native Interface (JNI) to communicate with the Access ODBC driver library. ![]() As far as the Office application is concerned, it is being accessed via the normal ODBC driver. As far as the Java application is concerned, it is using a normal JDBC driver. (ODBC is another data access technology, the Microsoft implementation of which is included with Windows.) To provide a JDBC interface to Office applications via this native Microsoft interface, a JDBC driver must be able to convert JDBC calls to ODBC calls. However, Microsoft do produce an ODBC driver for the Office suite. Microsoft do not produce a JDBC driver for Jet (the underlying database engine for the Microsoft Office product suite) or Jet's successors the Office Access Connectivity Engine and the Access Database Engine. A JDBC driver implements the JDBC API for a particular database. ![]() To interact with a database, a Java application uses a JDBC driver. JDBC is a Java application programming interface (API) that connects Java to relational databases (and other tabular data, such as spreadsheets and flat files). How to connect to Microsoft Access or Microsoft Excel from Java. Easysoft JDBC-Access Driver Getting Started Guide ![]()
0 Comments
Leave a Reply. |
AuthorWrite something about yourself. No need to be fancy, just an overview. ArchivesCategories |