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.