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.
I’ve looked at a lot of different solutions, and in my humble opinion Aspose is the way to go. Here’s the link: http://aspose.com
subject: Python script for to make a copy of DB2 database to MS Access format.