I dunno if this is the right forum, but I want to import and export data from Microsoft Excels, Access and Word (.DOC,.XLS,.MDB) to Hibernate data store.. does anyone have the reference/JAR to that???


Thank you in advance

You can use the sun jdbc-odbc bridge for accessing both Excel and Microsoft Access files via jdbc. However, it requires you have the appropriate ODBC drivers installed on your system, and the files
have to be on the same machine. To access files on another machine,
you can use RMI-JDBC bridge(http://java.sun.com/products/jdbc/faq.html#5, http://rmijdbc.objectweb.org/Access/access.html)


You can use xlsql [ https://xlsql.dev.java.net/ ] for purely jdbc
access, but it requires you to also have hypersonic sql available.
Basically, it converts excel files into a hypersonic database (in-memory
i believe). So, when you setup your dialect, have it use the one
for hypersonic.

As for MS Access, I'm not sure what pure java drivers (type 4) are
available, but I'm sure there's a commercial one out there (though I'm
not sure anyone would use access in production with a j2ee application
anyway, so there may not be a need)

So, I often work with office files, but with Excel documents I work more frequent. And consequently I had a lot of types of problems with such files. Once I had an very complicated issue. To be more precise some my xls files were lost. To my good fortune I got a solution - unable to read file xls. It resolved my issue for seconds and completely free of charge as I kept in mind. What is more I knew how the software solved problem with corrupted files in Microsoft Excel format and repaired Excel-unable to read file.