How to read MS Access db(.mdb file) in Spring batch and load into mysql db

Question

I want to read *.mdb file in Spring Batch and load into MySQL database.

Answer 1

There is no support for MS Access database format by default in Spring Batch. The first step is to see how to read data from a MS Access database using Java, then you can create an ItemReader and use it in a Spring Batch job.

Now in order to connect to a MS Access db from Java, you can see the following questions/answers:

• Manipulating an Access database from Java without ODBC
• How to connect java to Ms access Database

If you manage to create a jdbc DataSource pointing to a MS Access database, you can use the JdbcCursorItemReader (or JdbcPagingItemReader) and configure it with that DataSource (In this case there is no need to create a new reader).

Hope this helps.