changing schema of ms access database using java, eclipse, maybe spring

changing schema of ms access database using java, eclipse, maybe spring

I am a java programmer who uses eclipse, and who has been studying Spring
lately. I am starting a project in which I will need to
manipulate/transform a Microsoft Access 2010 database. For starters, I
need to do things like populate an empty table with hundreds of bogus
records for use in testing. Later, I will also need to do things like
select all the data from the old schema, rearrange it using
transformations of arraylists, and then insert all the transformed data
into the new database schema.
The problem is that I am not seeing straightforward examples of this kind
of thing on the web. I would prefer to write it in Java because I know
Java. Writing it in Visual Basic would make this a much harder project. I
imagine that this problem has been solved again and again by many people.
Can anyone point me to some examples of how to address this kind of
problem as simply as possible?