aspose file tools*
The moose likes JDBC and the fly likes How to get the DB dump from MS ACCESS using java code? Big Moose Saloon
  Search | Java FAQ | Recent Topics | Flagged Topics | Hot Topics | Zero Replies
Register / Login
JavaRanch » Java Forums » Databases » JDBC
Bookmark "How to get the DB dump from MS ACCESS using java code?" Watch "How to get the DB dump from MS ACCESS using java code?" New topic
Author

How to get the DB dump from MS ACCESS using java code?

prabhu pandurangan
Ranch Hand

Joined: May 23, 2008
Posts: 120
Hi All,

I need to get the database dump from Ms Access database, using java standalone application, using Java Runtime exec. process.

We have an functionality in Mysql 'mysqldump' but i do not know we have a similar kind of function in MS Access.

Kindly help me out in this. It would be better if i can get some sample code.

Regards,
Prabhu
Scott Selikoff
author
Saloon Keeper

Joined: Oct 23, 2005
Posts: 3710
    
    5

In Access, you can export the tables to CSV. In Java, though, you would have to query each table and pull each record. The Meta Data JDBC classes can assist in automating this, though.


My Blog: Down Home Country Coding with Scott Selikoff
Jan Cumps
Bartender

Joined: Dec 20, 2006
Posts: 2503
    
    8

Since Access is a file based database, can't you simply copy your database file(s)?

OCUP UML fundamental and ITIL foundation
youtube channel
 
I agree. Here's the link: http://aspose.com/file-tools
 
subject: How to get the DB dump from MS ACCESS using java code?