I want to write a program that is able to import data from an excel file and it can update the current mysql table. My question is how can add the import /update feature?
one other thing is that I want to do this in swing.
The common libraries for working with Excel files are Apache POI (for both XLS and XLSX) and jExcelApi (XLS only). I generally advise to use POI; even the beta versions of upcoming releases are quite stable.