I need to copy data from excel to ms access table. The excel sheet has around 7000 entries (that's only a part of what i am gonna add later) and it takes a lot of time to copy data (around 2-3 minutes).
Is there any way to improve the performance of the program. I am using JDBC-ODBC Bridge Driver to connect to excel and table and transfer data b/w them.
Thanks in advance
You could probably boost speed by using a native Excel reader such as Apache POI. The bridge driver is a last resort.
However you might also find it useful to get a copy of the Pentaho Data Interchange tool (also known as "Kettle"). It's a ready-made general-purpose Extract/Transform/Load application that can be "programmed" using a GUI designer app ("spoon"). It not only supports interchange to/from Excel and Access, but a lot of other things as well and it's tuned for automatic parallel processing. You can run it stand-alone or embedded into another app (Swing-based or not).
Disclaimer: I wrote some of the Excel support code for Kettle, so I'm not exactly unbiased.
An IDE is no substitute for an Intelligent Developer.
Joined: May 22, 2012
I have Apache POI. I would try to use that to improve performance. I would also look into your Pentaho Data Interchange Tool.