This is software that lets you migrate data from Access to the higher end DB2 automatically.
AccessToDB2 is a data conversion tool that helps DBAs and database programmers convert Access data to DB2 database. The configuration is made easy with the graphical interface. All it takes are a few mouse clicks. The interface is completely intuitive. You specify the table in Access that you are trying to import into DB2 database. You can select all the fields or a few chosen ones. This is easily clicked through checkboxes. When the option is to take all the fields to the destination, you can use a single mouse click that selects all. Similarly if you were to make a mistake, you can uncheck all and start over. In the source part specifications, you specify the Access file to be used. You`ll have to specify the table name too. View data button provides you access to viewing you table to make sure you have asked for the right table and have the right path.
You can choose to convert multiple tables also. On the destination side you need to specify schema and the table to which you are sending out the data. Then just say import and the data will start moving. A progress bar will show how the importing is progressing. Besides the visual indication, you will see a percentage display that tells you how much data has been imported. The stats also show the number of records imported and then the elapsed time is an indication of how much time it is taking. This would typically be handy whenever you are upgrading from Access to DB2. There may be a onetime huge load or you may be migrating day to day. Whichever way, this is a handy tool to have around.