This week's book giveaway is in the OCAJP 8 forum. We're giving away four copies of OCA Java SE 8 Programmer I Study Guide and have Edward Finegan & Robert Liguori on-line! See this thread for details.
I have a DB2 database and I need to make a weekly copy of that in MS Access database format. Is there any way or is there any library. I have heard python is very fast and easy to use language so I thought may be there is some option available?
I would put money on Access being able to open CSV files which you could save as an Access file. The ODBC link above specifically mentions Access.
I've had good results using Microsoft Data Transformation Services (now SQL Server Integration Services) to do database export/import. That would probably be the simplest method.
Define "better". Both languages have features for getting data out of a database and putting data in a file, so from a feature standpoint, they're pretty much even. Personally, I tend to use Python as a scripting language, automating repetitive tasks and I use Java for more enterprise level tasks like fully featured applications. This is not to say Python can't be used to make fully featured applications, it's just that I tend to use Java for that task.