CODEWITHSUNDEEP
javams-accessjdbcapache-poi
Karthik.m
Karthik.m

Reputation: 781

connect Ms Access to java

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

Upvotes: 1

Views: 1595

Answers (3)

BalusC
BalusC

Reputation: 1109292

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.

Upvotes: 1

mhaller
mhaller

Reputation: 14222

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

Upvotes: 0

Alex Martelli
Alex Martelli

Reputation: 882291

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!-)

Upvotes: 0

Related Questions