File APIs for Java Developers
Manipulate DOC, XLS, PPT, PDF and many others from your application.
http://aspose.com/file-tools
The moose likes JDBC 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
JavaRanch » Java Forums » Databases » JDBC
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.
 
Consider Paul's rocket mass heater.
 
subject: Import MS Access Database into DB2
 
Similar Threads
How to connect to remote Database Using IPAddress
Access database without using jdbc-odbc?
Is Noscroll a Database?
JDBC Tye 2 Driver
How to make SELECT statement case sensitive?