upload data from excel to access using java

Can anyone give me so开发者_JAVA百科me idea about uploading data from excel to access database using java

---

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.

---

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

---

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.