Can anyone give me some idea about uploading data from excel to access database using java
+2
A:
Why would you want to use Java for that? You can link Excel and Access data directly:
http://office.microsoft.com/en-us/access/HP010950951033.aspx
Ron
Ron Savage
2009-11-02 06:23:35
i need it as for my project requirement
Karthik.m
2009-11-02 06:26:09
+2
A:
You'll definitely want to check out Apache POI - Java API To Access Microsoft Format Files. You'll likely find the Excel bindings you need there. For MS Access, you'll want a JDBC Driver which you can find on Sun's website. Then you can just write the glue code.
Asaph
2009-11-02 06:27:21
+1
A:
I've used POI before to read and write Excel files. Once you got the data, use JDBC (maybe the JDBC/ODBC bridge) to load it into Access.
Thomas Müller
2009-11-02 06:29:55
Asaph mentioned a JDBC driver for Access. A dedicated driver would definitely be preferable over the JDBC/ODBC bridge.
Thomas Müller
2009-11-02 06:47:49
Yep you should definitely get you hands on a appropriate JDBC driver, I've used the JDBC/ODBC bridge before in combination with an Access database and alot of pretty basic JDBC things are unsupported (if I remember correctly even transactions were not supported).
NickDK
2009-11-02 08:58:50