Actually I am developing a java application in which I want to develop an import utility that will use JFileChooser, so how can I import Excel file appended to Access database.
POI and JDBC, respectively, solve those two problems. Have you read the web sites we pointed you to yet? Do you understand how they work? If not, what specifically are you unclear about?
(I don't understand what JFileChooser has to do with reading an Excel file, or with writing to a DB, so I can't speak to that.)
yes i have read the mentioned sites.
i am using jexcelapi for handling excel instead of POI.
and to connect with access i am using JDBC.
But the issue is that the database is in access and i want to develop a utility in my tool,
such that when ever one wants to add/update many records at a time, the user would not add each record by the GUI individually,
instead just import the excel and records get copied into access.
so i am thinking of using a JFileChooser to browse the excel file and then on click of a button to do the import thats copying of data to access.
so if any one has any idea about how to do so.
thanks...