This week's giveaway is in the Android forum.
We're giving away four copies of Android Security Essentials Live Lessons and have Godfrey Nolan on-line!
See this thread for details.
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


Win a copy of Android Security Essentials Live Lessons this week in the Android forum!
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
Saloon Keeper

Joined: Oct 23, 2005
Posts: 3703
    
    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: 2491
    
    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?
 
Similar Threads
JSP/Servlet With MS Excel?
Get index of a row
Quering the ResultSet
How to download a file from database
read data from MS Access db file in UNIX, using JAVA