aspose file tools
The moose likes JDBC and Relational Databases and the fly likes Import MS Access Database into DB2 Big Moose Saloon
  Search | Java FAQ | Recent Topics | Flagged Topics | Hot Topics | Zero Replies
Register / Login


Win a copy of OCA Java SE 8 Programmer I Study Guide 1Z0-808 this week in the OCAJP forum!
JavaRanch » Java Forums » Databases » JDBC and Relational Databases
Bookmark "Import MS Access Database into DB2" Watch "Import MS Access Database into DB2" New topic
Author

Import MS Access Database into DB2

Jan Jansen
Greenhorn

Joined: Feb 24, 2003
Posts: 2
This may be an elementary question, but how do I go about importing an Access database into DB2? Thanks!
Abbas Alafoo
Greenhorn

Joined: Feb 06, 2003
Posts: 24
I had a similar case when I needed to export SQL Server database to DB2.
I first generated the DDL commands, and executed them on DB2, then I exported each table data into a text file, and then imported that file in DB2.
I'm not sure if there is an easier way, but my trial did work.


SCJP
Jan Jansen
Greenhorn

Joined: Feb 24, 2003
Posts: 2
Thanks for your reply. I've decided to use a software that will convert the data from Access to DB2. It'll be much easier that way.
 
 
subject: Import MS Access Database into DB2