connect Ms Access to java

Question

I extracted data from excel using poi api. Now I want to store the data in access please clarify

Answer 1

You need something like JetProxy -- a JDBC driver interfacing to Jet (the internal name of Microsoft Access's own quasi-relational sort-of-SQL DB engine). There are other products much in the same vein, but I have no personal experience to help suggest which product is best for your purposes -- just try a few!-)

Answer 2

You can either use the commercial JDBC drivers by HXTT or the JDBC-ODBC bridge by Sun

Answer 3

To the point, you just want to "convert" Excel to MSAccess using Java code? Here are the steps:

1) Extract data from Excel into Java objects (List, String, Number, Javabean, etc). 2) Insert the data in flavor of those Java objects into MSAccess.

That's basically all. For 1) you can use under each the Apache POI as you already found out. For 2) you can use the JDBC. I think your problem is more that you don't understand what JDBC is and how to work with it. In that case you may find the Sun's JDBC tutorial useful. Good luck.